|
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 |