Raw Data shows dates in U.S. format. Depending on your Windows Regional Settings, raw data may be displayed in a different format.
DateTime Mask Type
Mask
Raw Data
Formatted Data
mm/dd/yyyy hh:mm:ss.fff
12/8/1969 2:06:45 AM
12/08/1969 02:06:45.000
mm/dd/yyyy hh:mm:ss.f
12/8/1969 2:06:45 AM
12/08/1969 02:06:45.0
Special Note
Raw Data shows dates and times in U.S. format. Depending on your Windows Regional Settings, raw data may be displayed in a different format.
Numeric and Currency Mask Type
Mask
Raw Data
Formatted Data
$#,##0;($#,##0)
1001.536
$1,002
$#,##0;($#,##0)
-1001.536
($1,002)
0.00
-0.2
-0.20
00000
123
00123
-> *<-
104
-> 104<-
0.
30.2500
30.25
+0.00;-0.00
12
+12.00
Special Note
Be careful with "$", because this simply adds the literal dollar symbol to the mask. If you want your mask to adjust the currency symbol according to the Windows locale currency setting, then do not use literal symbols like "$" in your mask. The Default_Currency_Symbol() function can be used to build a mask string that will substitute the Windows locale currency symbol into your mask at run time. See Default_Currency_Symbol for more information.