- Select the numeric data.
On the Home tab, in the Number group, select the small arrow to open the Dialog box.
- 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.
M365 Excel - Create a custom number format
Comments
0 comments
Please sign in to leave a comment.