Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Formatting Numbers< Previous | Next > 

 

Basic

 
Expand

 -

Getting Started

Step By Step

 -

Built-in Number Formats

Step By Step

 -

Displaying Numbers

Step By Step

 -

General Format

Step By Step

 -

Number Format

Step By Step

 -

Currency Format

Step By Step

 -

Accounting Format

Step By Step

 -

Date Format

Step By Step

 -

Time Format

Step By Step

 -

Percentage Format

Step By Step

 -

Fraction Format

Step By Step

 -

Scientific Format

Step By Step

 -

Text Format

Step By Step

 -

Special Format


 

Custom Number Formats

 
More Details

 -

Custom Number Formats

More Details

 -

Custom Number Formats - Examples

More Details

 -

Custom Number Formats - Creating


 

Advanced

 
More Details

 -

Automatic Number Formatting

More Details

 -

Rounding Errors

More Details

 -

Copying and Pasting

More Details

 -

Fixed or Floating Decimals

More Details

 -

Fractions

More Details

 -

Text to Numbers

More Details

 -

Useful Number Functions

More Details

 -

Advanced Techniques

More Details

 -

Version Changes

More Details

 -

Office Online

More Details

 -

Knowledge Base

More Details

 -

Knowledge Base - Numerical

More Details

 -

VBA Code


 

Shortcut Keys

 
 

(Ctrl + Shift + ' ) - Applies the Time format "hh:mm" to the selection.

 
 

(Ctrl + Shift + 1) - Applies the Comma separated format "#,##0.00" to the selection.

 
 

(Ctrl + Shift + 4) - Applies the Currency format "£#,##0.00" to the selection.

 
 

(Ctrl + Shift + 5) - Applies the Percentage format "0%" to the selection.

 
 

(Ctrl + Shift + 6) - Applies the Exponential format "#,##E+02" to the selection.

 
 

(Ctrl + Shift + # ) - Applies the General format to the selection.

 

 

Related Sections

 
GoTo

 -

Dates & Times

GoTo

 -

Text Manipulation


 © Better Solutions Limited 10-May-2013Top