January 25, 2014
I am constantly generating financial reports with monetary numbers. I have to go through several steps to format the value in the desired format.
I use the "accounting" number format.
Then I change decimals to zero.
Then I choose none for the currency symbol.
How would I just create a custom format I can choose from the format selection that does all these steps in one click?
July 16, 2010
April 21, 2015
I was wondering why you don't use the 'number' format, so you don't have to delete the currency symbol?
And second I think you can make a custom format with these settings and use that for the next report (maybe you have to have the report with these settings open, or (as Mynda says) you save it as a default workbook setting.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas