Here is tip #7 in a series of an Excel Tip a Day for December 2015 – Display your numbers as millions. Tips range from the obvious to the simple to some more complex tips. Hopefully there is something you find helpful!
If you work with spreadsheets with large numbers (we all love that, right?), it is often unsightly to show those numbers in full. “$12,158,168.05″ really doesn’t say any more than “$12.16m”, particularly on an output sheet. In order to change $12,158,168.05 to $12.16m, follow these steps:
- Select the cell(s) you wish to format.
- On the Home ribbon, press the little down arrow in the bottom right of the number format window. It’s the one with “Currency” at the top.
- In the Category list on the Number tab, choose Custom.
- In the text box under the word “Type:”, type in $0.00,,”m”
Done! If you want more or less decimals, add or subtract 0’s after the decimal in the above format.
I hope you find this helpful!