Hello, I am trying to attribute symbols (up/down triangle) when formatting a number with the num() function. I mange to get the correct values (333%) when I place the chr() symbols before the format type, but not when I place them after (I get 3%). I don't seem to find what's wrong and the correct nomenclature. May someone shed a light and help here, please? Can check this on my example below. Thank you!
Solved! Go to Solution.
Have you tried like this?
=Num(10/3,'▲ #,##0;▼ #,##0')
and add your text color expression as
Strangely it works yeah . I thought it wasn't gonna work because in my real cases it ended up giving me 0 as a value, but apparently multiplying by 100 makes it return the correct value again.