Showing Millions in M on Cells

Ever wondered how you could have a figure such as 2,265,450 displayed as 2.26 M?

It is very simple to do.

1. Select all the cells that contain the values
2. Choose Format > Cells...
3. Ensure that you have Number tab selected
4. Choose Custom on the left hand side
5. Type the following in the Type: box (You can copy and paste it if you're feeling a bit lazy :)
[>=1000000]0.00,,"M"

And WALLAW! You get what you want! If you do want to see more numbers you can use the Increase and Decrease decimal buttons!

For downloading more tiops and trick and shortcust download FREE Manuals from http://www.mousetraining.co.uk/ms-office-training-manuals.html

Hope you have a nice day and thanks for visiting my blog!!