Format Library

Common number and date format examples you can copy or customize.

Formats are sensitive to language and regional settings. Your current settings: English (United States), Excel.

Finance & Accounting

Financial Statement Format

_(#,##0_);(#,##0);_(#,##0_);_(@_)

12,345

Millions with Aligned Dollar Sign

"$"* 0.0,,"M";"$"* -0.0,,"M"

$ 1234.6M

Red Negative Numbers

#,##0.00;[Red]-#,##0.00

-1,234.56

Suffix Inside Parentheses

_(0.0"x"_);(0.0"x");_(0.0"x"_);_(@_)

(12.3x)

Projected Year Format

_(0"P"_);(0"P");_(0"P"_);_(@_)

2030P

Format Name	Format Code	Example Output	Actions
Financial Statement Format	`_(#,##0_);(#,##0);_(#,##0_);_(@_)`	12,345	Edit
Millions with Aligned Dollar Sign	`"$"* 0.0,,"M";"$"* -0.0,,"M"`	$ 1234.6M	Edit
Red Negative Numbers	`#,##0.00;[Red]-#,##0.00`	-1,234.56	Edit
Suffix Inside Parentheses	`_(0.0"x"_);(0.0"x");_(0.0"x"_);_(@_)`	(12.3x)	Edit
Projected Year Format	`_(0"P"_);(0"P");_(0"P"_);_(@_)`	2030P	Edit

US Date Format

mm/dd/yyyy

01/09/2026

24-Hour Time

hh:mm

14:24

Full Date with Weekday

dddd, mmmm" "dd, yyyy

Thursday, January 01, 2026

12-Hour Time with AM/PM

h:mm" "AM/PM

2:24 PM

Date and Time

dd/mm/yyyy" "hh:mm

01/01/2000 14:24

Format Name	Format Code	Example Output	Actions
US Date Format	`mm/dd/yyyy`	01/09/2026	Edit
24-Hour Time	`hh:mm`	14:24	Edit
Full Date with Weekday	`dddd, mmmm" "dd, yyyy`	Thursday, January 01, 2026	Edit
12-Hour Time with AM/PM	`h:mm" "AM/PM`	2:24 PM	Edit
Date and Time	`dd/mm/yyyy" "hh:mm`	01/01/2000 14:24	Edit

Percentage with Dash for Zero

_(#,##0.00%_);(#,##0.00%);_("-"_)"%";_(@_)

23.00%

Percentage with Red Negatives

0.00%;[Red]-0.00%

-15.23%

Format Name	Format Code	Example Input	Example Output	Actions
Percentage with Dash for Zero	`_(#,##0.00%_);(#,##0.00%);_("-"_)"%";_(@_)`		23.00%	Edit
Percentage with Red Negatives	`0.00%;[Red]-0.00%`		-15.23%	Edit