Create or delete 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 More in the Number group.
Select Custom.
In the Type list, select an existing format, or type a new one in the box.
-
To add text to your number format:
Select OK.
Source: Microsoft