1 min readfrom 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"

submitted by /u/bluntvibes
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#financial modeling with spreadsheets
#real-time data collaboration
#real-time collaboration
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis