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!!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment