Create a custom number format

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.