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