Add text and data

Build custom numeric formats

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Try it!

Create and build a custom numeric format to show your numbers as percentages, currency, dates, and more.

  1. If there's data you'd like to apply a custom format to, select it.

  2. Select More in the Number group.

  3. Select Custom.

  4. In the Type list, select an existing format, or type a new one in the box.

  5. To add text to your number format:

    • Type what you want in quotation marks.

    • Add a space to separate the number and text.

  6. Select OK.

Want more?

Create or delete a custom number format

Discover more courses like this at LinkedIn Learning

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.

×