| |
Format Definition Column
The following table lists the built-in number, currency, date and time formats and the result of applying the format.
| Category |
Format |
Result |
| Number |
#;(#) |
13333 |
| #,###;(#,###) |
13,333 |
| #,###.00 |
13,333.45 |
| #,###.0000 |
13,333.4500 |
| 0000000 |
0013333 |
| Currency |
$#,##0.00;$(#,##0.00) |
$13,333.45 |
| $#,##0.00;[Red]$(#,##0.00) |
$(13,333.45) |
| Date |
m/d/yy |
2/3/99 |
| mm/dd/yyyy |
02/02/1999 |
| dddd, mmmm d, yyyy |
Thursday, February 3, 1999 |
| d/mmm |
3/Feb |
| mmm/yy |
Feb 99 |
| d/mmm/yy |
3/Feb/99 |
| mmm |
Feb |
| mmmm |
February |
| Time |
hh:mm AM/PM |
03:29 PM |
| hh:mm:ss AM/PM |
03:29:41 PM |
| hh:mm |
15:29 |
| hh:mm:ss |
15:29:41 |
| mm:ss |
29:41 |
| h:mm:ss |
1:09:33 |
| mm/dd/yyyy hh:mm AM/PM |
02/03/1999 03:29 PM |
You can get creative and drum up your own format by using a combination of the formats above.
|