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.
No comments:
Post a Comment