Custom Formats Builder

for Microsoft Excel
and Google Sheets
I'm formatting a:

Quick Reference

Placeholders

Symbol Description
0 Display insignificant zeros
# Display significant digits
? Display aligned decimals
. Decimal point
, Thousands separator
* Repeat digit to fill cell
_ Add space

Fractions and Percents

Symbol Description
/ Fraction Bar
% Percent Sign

Dates

Symbol Unit Display (ex: March 8th, 2018)
m Month 3
mm Month 03
mmm Month Mar
mmmm Month March
mmmmm Month M
d Day 8
dd Day 08
ddd Day Thu
dddd Day Thursday
yy Year 18
yyyy Year 2018

Times:

Symbol Unit Display (ex: 9:05:01 AM)
h Hours 9
hh Hours 09
m Minutes 5
mm Minutes 05
s Seconds 1
ss Seconds 01
[h] Elapsed Hours 9
[hh] Elapsed Hours
(w/ leading zero)		 09
[m] Elapsed Minutes 545
[mm] Elapsed Minutes
(w/ leading zero)		 545
[s] Elapsed Seconds 32701
[ss] Elapsed Seconds
w/ leading zero)		 32701
AM/PM AM or PM AM
a/p a or p a

Text

Symbol Description
\ Escape character. Use it before another symbol to display that symbol as text.
"" Quotation marks. Use text in quotation marks to display it literally.

Other Resources

For a detailed overview, see Exceljet's Custom Number Formats article.

positive
negative
zero
text
Unformatted
Formatted
→
→
→
→
→
→
→
→
Lorem ipsum dolor sit amet consectetur, adipisicing elit. Commodi natus voluptates odit expedita laudantium quis repudiandae tempora possimus laboriosam enim est quia quaerat aperiam iusto, accusamus maxime at velit quo. Lorem ipsum dolor sit amet consectetur, adipisicing elit.

Examples

Numbers

Currency

Fractions

Percents

Dates

Time

Text

Other

About

This is a scratchpad for building custom formats for Microsoft Excel and Google Sheets.

It was made by me, Bryan Braun 👋.

The source code can be found here on Gitlab.

Special thanks to the SheetJS SSF project, which powers the formatting engine.

Issues

The Custom Formats Builder is in beta. Here are some things it's currently missing:

If you find any other issues you can log them here.