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

@