One of the biggest time-savers in Excel is to let the program automatically format your numbers.
For example, if your number is $1,000,000, you may want to display the number:
- In thousands: $1,000
- In millions: $1
- $1 M
- $1 Million
John Peltier of PTS provides a comprehensive list of examples on how to create custom number formats. I suggest that you bookmark this page to increase the efficiency of your spreadsheets.
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare