Converting an absolute value to Millions view is task unless you that it is possible to do in a easier way.
Below are two methods:
1. Using concatenation and division.
2. Right click on the value and go to format cells, select custom on left hand side. Now enter #0,"M" in the text box under Type header on right hand side.
The difference between the first and second method is in the first method the formula bar doesn't show the value instead shpws the formulae used to convert to Millions.
In the second method, the original value is shown as is and doesn't affect user experience.
Additionally, you can use the custom formatting to show text which doesn't show in formula bar like below.
Formula Bar:
Custom Format used:
No comments:
Post a Comment