![]() |
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 |
All times are GMT +1. The time now is 07:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com