How to show a value in Millions in Excel
Update 2025: If you are looking for the best hardware to handle this kind of analysis, check out my new guide on the Top 5 Tools Every Data Analyst Needs
In these cases you can use the "Custom" Format to mask the value into showing in millions. As shown above enter "#0.0,, "M" without quotes and the value will be shown in Millions. Observe the formula bar the value is not modified but the way it is represented is masked in the cell.
In Excel, when are designing a dashboard with big figures like number which runs into Millions. Its not a good idea to show all the digits in the cell as this might make the dashboard look very busy and doesn't make any sense to the executives who would review it.
In these cases you can use the "Custom" Format to mask the value into showing in millions. As shown above enter "#0.0,, "M" without quotes and the value will be shown in Millions. Observe the formula bar the value is not modified but the way it is represented is masked in the cell.