2
1
I would like to display 0.37 as 37¢, in Excel. I can do .37¢ with the format .00¢, but 00¢ doesn't work, cause it works with the whole number part.
I know the percentage sign works with the next two digits, like I would like to do, so maybe there is a way to do a percentage formatting, and have a different character in place of the percent sign?
Why does 0.00 " c" divide the numbers by 1000? – ahorn – 2017-02-24T06:47:06.153
Problem solved: I needed to remove the space.
0.00" c"
works. – ahorn – 2017-02-24T06:59:10.887