Excel Format Builder
Build custom number and date format codes for Excel and Google Sheets with an intuitive visual interface.
Input
Excel Configuration (English, United Kingdom)
General
Add commas to separate thousands (e.g., 1,000)
Number of digits after the decimal point
Displays value as a percentage. Multiplies by 100 and adds % sign
Negative and Zero
Display format for negative numbers
How to display zero values
Prefix and Suffix
Color
Text
Output
Excel Format Code
Custom Number
1234.56
Example Numbers
10000000
10000000.00
1234567.89
1234567.89
1234.5678
1234.57
123.45
123.45
12
12.00
0
0.00
-12
-12.00
-123.45
-123.45
-1234.5678
-1234.57
-10000000
-10000000.00