Rounding a number to make a report look tidier means the figure other formulas rely on is no longer accurate.
A custom number format solves this by changing only how a value is displayed, leaving the real number completely untouched underneath.
Here's the trick:
A custom number format changes how a value displays while keeping the exact figure intact for formulas.
How to use it
- Select the cells you want to reformat.
- Press Ctrl+1 to open Format Cells.
- Go to the Number tab and choose Custom.
- Enter a format code, such as $#,##0,"k", and click OK.
Where it helps most
Dashboards and summary reports where large numbers need to look clean without permanently altering the underlying data that other formulas still depend on.
One thing to watch for
Custom format codes are easy to get slightly wrong on the first try. Test one on a copy of a single cell before applying it across an entire report.
Found a faster way to do this, or a version that works differently on Mac? That's what the comments are for — this section connects to your comment system of choice (Disqus, giscus, etc.) once the site is live.