Cannot Paste Symbols in Custom Formatting

New Contributor

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

3 Replies

@Elliab Have a look at the attached file. Should work.

 

@Riny_van_Eekelen Thank you for your solution. 

@Elliab You're welcome!