You can divide numbers by 1,000,000 to display in millions, but this changes the value of the number. A better way to display numbers in millions is to use a Custom Number Format.
- Choose Format > Cells
- On the Number tab, select Custom from the Category list
- Paste one of the following formulas in the Type field
- To display millions with one decimal, paste #.0,,;(#.0,,)
- To display millions with a dollar sign and one decimal, paste $#.0,,;($#.0,,)
- To diplay millions with two decimal places, paste #.00,,;(#.00,,)
- To diplay millions with a dollar sign and with two decimal places, paste $#.00,,;($#.00,,)
- To diplay millions with three decimal places, paste #.000,,;(#.000,,)
- To diplay millions with a dollar sign and three decimal places, paste $#.000,,;($#.000,,)
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare
2 Comments so far (Add 1 more)