Forum Discussion
Cannot Paste Symbols in Custom Formatting
Elliab Have a look at the attached file. Should work.
Riny_van_Eekelen Thank you for your solution.
Elliab You're welcome!
- Can you explain how you did this? I'd like to be able to add other symbols to custom number formats but don't know how to do it.
Mike_Williams695 Well, find the symbols you want to use first and copy them into a cell, as shown in the file that accompanied my original answer. Now create a custom number format.
On the Home tab, in the Number group, click More Number Formats at the bottom of the Number Format list
In the Format Cells dialog box, under Category, click Custom.
In the Type list, select the built-in format that most resembles the one that you want to create. The number format that you select appears in the Type box.
In the Type box, modify the number format codes to create the exact format that you want. For example, 0▲;0▼
The last bit is done step by step. Copy the arrow-up symbol from the Excel sheet. Navigate to the Type box. enter 0 and Ctrl-V. Press OK. Copy the arrow-down symbol from the Excel sheet. Go back to the Type box and select the format you just creates and continue typing ;0 and Ctrl-V to create this format "code": 0▲;0▼
Press OK.
Don't really know how else I can explain it. Most off the text above comes from the link below, in case you want to know more about custom formatting.
