The following table shows some examples of custom number formats and numbers displayed using the custom formats.
| Format | Cell Data | Displays |
|---|---|---|
| #.## |
123.456 0.2 |
123.46 .2 |
| #.0# |
123.456 123 0 -123.45 |
123.46 123.0 0 123DR |
| #, | 10000 | 10 |
| $ #,##0.00;$ -#,##0.00 |
1234.567 -12.34 |
$ 1,234.57 $ -12.34 |
| 000-00-0000 | 123456789 | 123-45-6789 |
| \C\u\s\t\. \N\o\. 0000 | 1234 | Cust. No. 1234 |
| m-d-yy | 2/3/13 | 2-3-13 |
| mm ddyy | 2/3/13 | 02 03 13 |
| mmm d, yy | 2/3/13 | Feb 3, 13 |
| mmmm d, yyyy | 2/3/13 | February 3, 2013 |
| d mmmm yyyy | 2/3/13 | 3 February 2013 |
| hh\h mm\m | 1:32 AM | 01h 32m |
| h.mm AM/PM | 14:56 | 2.56 PM |
| hhmm \h\o\u\r\s | 3:15 | 0315 hours |