| Alpha-numeric format | @Sn, where n represents the number of characters allowed
|
| [e.g. @S10 , @S5 ]
|
|
|
| Numeric format | @Ndd.cc, where dd represents the total digits allowed (including decimal point, and symbols) and cc represents the number of decimal places
|
| [ e.g. @N12.3, @N16.3, @N$(11.2) ]
|
|
|
| Short Date Format | @D1 - m/d/yy
|
| @D01 - mm/dd/yy
|
|
|
| Long Date Format | @D2 - m/d/yyyy
|
| @D02 - mm/dd/yyyy
|
|
|
| System Date Format | @D17 - the date format set on your computer
|
|
|
| System Time Format | @T7 - the time format set on your computer
|
|
|
| Blank when zero/null | b added to the end of a format specifies blank when zero
|
| [ e.g. @N5b, @D1b ]
|
|
|
| Special Formats
|
|
|
| Phone Number | @P(###) #######P
|
| Social Security Number | @P###-##-####P
|
|
|