Help, tips, tricks and tutorials for Microsoft Office 2007 - The New Paperclip
9th March
2010
written by The New Paperclip




Do you prefer to use commas when you write long numbers?  Those commas are called “Thousands Separators”, and you can quickly add them to the cells in your Excel 2007 spreadsheet.

To turn on the thousands separator:

1) Select the cells you want to apply the commas to

2) Make sure you are on the “Home” tab of the ribbon

3) Look for the “Number” group – in the middle of the ribbon

4) Click on the button that looks like a comma!

 

‘till next time!
TNP ;)

Share and Enjoy:
  • del.icio.us
  • E-mail this story to a friend!
  • StumbleUpon

Related posts:

  1. Add Commas to your numbers in Excel 2007
  2. Merge and Center in Excel 2007
  3. Borders the EASY way in Excel 2007 – Just draw them!
  4. Word 2007: How to add page numbers to your documents
  5. Excel 2003 buttons and commands in Excel 2007

Tags:

Leave a Reply

Join the Office 2007 Tips and Tricks Newsletter Name:Email:
-->