Register
Log In
Unanswered
Home
New Member
January 25, 2014
Offline
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
Offline
Hi David,
You can either record a macro that applies that formatting and then assign it to a button on the QAT (Quick Access Toolbar) or a shortcut key. Or you can customise your default workbook to contain that formatting.
Hope that helps.
Mynda
Dashboards
Power BI
Power Query
April 21, 2015
Offline
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.
Frans
Most Users Ever Online: 57
Currently Online: azri adrin, Mark Lund, Rudi
23 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Joy Berryhill
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
