Nov 13 2021 06:18 AM
Hi,
I have been trying to paste the symbols
▲▼ |
as part of my custom number formatting in Excel. When numbers are positive it shows the up arrow and when negative it shows the down symbol. However, I am unable to paste these symbols in the type list box. Currently using Excel 365
Nov 13 2021 06:29 AM
@Elliab Have a look at the attached file. Should work.
Nov 25 2021 12:02 AM
@Riny_van_Eekelen Thank you for your solution.
Dec 19 2022 07:06 AM
Dec 19 2022 10:00 PM
@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.
Dec 20 2022 08:35 AM
Dec 20 2022 10:14 AM
@Mike_Williams695 Sorry, I don't know why it doesn't work work for you.
Feb 04 2023 09:01 AM
Feb 04 2023 09:39 AM
Feb 06 2023 05:11 AM