•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Saving Custom Number Formats Across Workbooks for Dollars and Units
I work in marketing and am frequently formatting my cells with the custom number format to make it easier to read units and dollars.
Currently I am just copying and pasting into the custom formatting bar each time I create a new workbook. Does anyone know of a way to save this formatting so each time I open a new workbook it is already in the dropdown menu?
Units with thousand, million, or billion labeling:
[<999950]0.0,"K";[<999950000]0.0,,"M";0.0,,,"B"
Dollars with thousand, million, or billion labeling:
[<999950]$0.0,"K";[<999950000]$0.0,,"M";$0.0,,,"B"
[link] [comments]
Want to read more?
Check out the full article on the original site