Create a custom number format

Create and build a custom numeric format to show your numbers as percentages, currency, dates, and more. To learn more about how to change number format codes. Select the numeric data.

Select the numeric data.Numeric Data
On the Home tab, in the Number group, select the small arrow to open the Dialog box.
Select Custom.

Custom
In the Type list, select an existing format, or type a new one in the box.Type List
To add text to your number format:
- Type what you want in quotation marks.
- Add a space to separate the number and text.
Select OK.

Custom Dialog box