Custom Format for ¢

S

Stephen POWELL

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top