Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Formatting Numbers< Previous | Next > 

 

Basic

 
Expand

 -

Getting Started

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

Step By Step

 -

Built-in Number Formats


 

Custom Number Formats

 
More Details

 -

Custom Number Formats

More Details

 -

Custom Number Formats - Examples

More Details

 -

Custom Number Formats - Creating


 

Advanced

 
More Details

 -

Displaying Fractions

More Details

 -

Text to Numbers

More Details

 -

Useful Number Functions

More Details

 -

Rounding Errors

More Details

 -

Advanced Techniques

More Details

 -

Office Online

More Details

 -

Knowledge Base


 

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 Topics

 
GoTo

 -

Dates & Times

GoTo

 -

Text Manipulation


 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top