Millions in Excel
Excel has some cool formatting tricks up its sleeve and one of these is its ability to shrink really big numbers down to size.
So, if you have values in the millions - like your salary - Ha!, you can size them down to size using a custom format. Select the cells, choose Format, Cells, Number tab and click the Custom group and type #,,"M" and Excel will format 200,000,000 to read 200M! The numbers aren't altered it's just a simpler way of displaying them.
Since the Y axis of a chart inherits its formatting from the top left cell in the chart data range this lets you format a chart's Y axis to show the smaller values too.
Labels: Excel 2003, Excel 2007, number format
posted by Projectwoman @ 10:55 AM
5 Comments:
Perfect for millions does it work the same way for thousands eg 20K
Would this work for 1000's eg 20k?
Just drop one of the commas for Thousands.
#,"k" for 20,000 to become 20k.
is there a way to combine both formula into one, so that various figures can just use one formula?
ie 1,000,000 as 1M; 100,000 as 100K
format to use:
[>1000000]$#.0,,"m";[>1000]$#,"k";$#,##0
for details or explanation refer to the website below:
http://excel.tips.net/Pages/T003528_Notation_for_Thousands_and_Millions.html
Post a Comment
Please feel free to add your comment here. Thank you!
Links to this post:
Create a Link
<< Home