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:
-
Type what you want in quotation marks.
-
Add a space to separate the number and text.
-
-
Select OK.
Source: Microsoft