Cannot Paste Symbols in Custom Formatting

New Contributor


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!