A Display Format is a text string that the program will use to know how to display a date, time, or numeric value. Below is a list of different display format text strings and examples of how the data would look when displayed using the format.
Some common Date/Time Display Formats
Format Text Example
m/d/yy 9/5/01
mm/dd/yy 09/05/01
mmm-d-yyyy Sep-5-2001
mmmm d, yyyy September 5, 2001
ddd, mmm-d-yy Sat, Sep-5-01
dddd, mmmm d, yyyy Saturday, September 5, 2001
yyyy-mm-dd 2001-09-05
m/d/yy h:nn AMPM 9/5/01 4:12 PM
dd/mm/yy hh:nn 05/09/01 16:12
Some common Numeric/Currency Display Formats
#,##0;-#,##0 -128,047
#,##0;(#,##0) (128,047)
$#,##0.00;($#,##0.00) ($128,047.00)
£#0.00;-£#0.00 -£128047.00
Add to favorites