Pick a date format from the list, enter a value (text) and click Submit to see how demo applies custom date format to a grid cell and displays your value in it.
For the NumberType detail information please see: Formatting Cells
| Reload Data: | |||
|---|---|---|---|
| Custom Format: | Input Value: |
Value |
Type |
Format String |
|---|---|---|
0 |
General |
General |
1 |
Decimal |
0 |
2 |
Decimal |
0.00 |
3 |
Decimal |
#,##0 |
4 |
Decimal |
#,##0.00 |
5 |
Currency |
$#,##0;$-#,##0 |
6 |
Currency |
$#,##0;$-#,##0 |
7 |
Currency |
$#,##0.00;$-#,##0.00 |
8 |
Currency |
$#,##0.00;$-#,##0.00 |
9 |
Percentage |
0% |
10 |
Percentage |
0.00% |
11 |
Scientific |
0.00E+00 |
12 |
Fraction |
# ?/? |
13 |
Fraction |
# / |
14 |
Date |
m/d/yy |
15 |
Date |
d-mmm-yy |
16 |
Date |
d-mmm |
17 |
Date |
mmm-yy |
18 |
Time |
h:mm AM/PM |
19 |
Time |
h:mm:ss AM/PM |
20 |
Time |
h:mm |
21 |
Time |
h:mm:ss |
22 |
Time |
m/d/yy h:mm |
37 |
Currency |
#,##0;-#,##0 |
38 |
Currency |
#,##0;-#,##0 |
39 |
Currency |
#,##0.00;-#,##0.00 |
40 |
Currency |
#,##0.00;-#,##0.00 |
41 |
Accounting |
_ * #,##0_ ;_ * "_ ;_ @_ |
42 |
Accounting |
_ $* #,##0_ ;_ $* "_ ;_ @_ |
43 |
Accounting |
_ * #,##0.00_ ;_ * "??_ ;_ @_ |
44 |
Accounting |
_ $* #,##0.00_ ;_ $* "??_ ;_ @_ |
45 |
Time |
mm:ss |
46 |
Time |
h :mm:ss |
47 |
Time |
mm:ss.0 |
48 |
Scientific |
##0.0E+00 |
49 |
Text |
@ |