About custom number, date, and time format codes

Custom number formats If a built-in number format is not available to display data the way you want, you can create a custom format.

Format codes You create custom number formats on the datasheet by specifying format codes that describe how you want to display a number, date, time, or text. You can specify up to four sections of format codes. The sections, separated by semicolons, define the formats for positive numbers, negative numbers, zero values, and text, in that order. If you specify only two sections, the first is used for positive numbers and zeros, and the second is used for negative numbers. If you specify one section, all numbers use that format. If you skip a section, include the ending semicolon for that section.

number format codes

More information

Number, date, and time format codes

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.