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

Format Name	Format Code	Example Input	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

Date & Time

Format Name	Format Code	Example Input	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

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