Custom Format for ¢
Is there a custom format that will multiply, say, $0.25 by 100 and show it as
25¢? (By analogy, placing a comma after the final zero in the custom format
and adding the letter K will divide the number by 1,000 to make 1,000,000
look like 1,000K so I hope I can made numbers less than $1 appear as ¢
without leading decimals.)
Stephen Powell
|