Input Formats

Example
Short Date
Medium Date
Long Date
Custom Date
   (yyyy-MM-dd)
Short Time
Medium Time
Long Time
Yes/No
   (value = 1)
General Number
Fixed
Standard
mp (Metric Prefix)
   (value = 310,340)
mps# (rounds mp)
   (value = 123,456)
Currency
Custom Number
   (£###,##0.00)
(to Upper Case)
(to Lower Case)