Hi Fellow Excel Addict,

How has your week been? I've had a pretty great week. The NHL playoffs are finally over and, even thought the Calgary Flames didn't win the Stanley Cup, I did win the hockey pool at work. That was a pretty good consolation prize.

I'm running a little late this week but I wanted to make sure you didn't miss out on a week of time-saving tips.

If you know any tips that you haven't seen in my newsletter so far and you think others would like to know, just send them to me and I'd be happy to share them with everyone in a future newsletter.

In the meantime, take care and keep Excelling!

To your success,
Francis J Hayes (The Excel Addict)

P.S. VERY IMPORTANT Please remember to include "TheExcelAddict" in the Subject line of any email you send me. This will help it stand out in the flood of junk email I have been receiving lately.

DISCOVER NEWFOUNDLAND AND LABRADOR, CANADA:
This is where I grew up: http://www.brigus.net/
This is where I now live: http://www.conceptionbaysouth.ca/
This is my beautiful province: http://www.gov.nf.ca/tourism/

Beginning with Excel 2002, you are now able to add color to your sheet tabs. For example, you could make the tabs of related sheets the same color. To change the color of a sheet tab, right-click on the tab and choose Tab Color. Select a color and click OK. To remove the color from your tabs, follow the same procedure and choose the No Color option.

Jim Rohn's Weekly E-Zine is a free weekly publication dedicated to providing valuable insights and information that can help empower and improve both your business and personal life. Find out more at http://www.TheExcelAddict.com/rd/jimrohn.htm.

All you have to do to qualify each month is send an email to your Excel friends and associates recommending my newsletter and website. Include a BCC to francis@TheExcelAddict.com and for each person that you refer, your name will go into the draw. Please, recommend only to people you know and who are Microsoft Excel users.

All you have to do each month is click here to recommend my newsletter and website to a friend. For each person that you refer, your name will go into the draw. The more Excel friends you refer, the more chances you have of winning, but please, recommend it only to people you know and who are Microsoft Excel users.

If you use the 'Tell A Friend' link at www.TheExcelAddict.com you could win $10,000 and you will also qualify for my Referral Contest draw.

*** Each monthly winner will be notified by email and will have 10 days to reply with a shipping address. If I don't receive a reply within 10 days, another name will be drawn.

Referral Contest Winners
March February January December November October September August July June	Mike Lowry, Cairnes, Australia Ashley Rankine, Perth, Australia Luis Bolivar, Maracaibo, Venezuela Joseph Mathew, Dubai, United Arab Emirates Alexandre Gusmao, Lisbon, Portugal Apollo Tigalo, Angeles City, Philippines Jim Henderson, California, USA Beki Chambers, Indiana, USA Keith Bannister, North Carolina, USA Lisa Hobbs, Pennsylvania, USA

Often in Excel, when working with large numbers it is common practice to show numbers as thousands, with a note to that effect shown somewhere on the report. To display your numbers to the nearest thousand in Excel you do not need to change any numbers or do any conversions. You simply change the way the number is displayed by creating a custom number format.

1. Select the cells containing the numbers you want to display as thousands.
2. Select Format, Cells, and click the Number tab.
3. In the Category box select Custom
4. In the Type box enter and click OK

Always remember that formatting a number has no effect on its underlying value.

One issue you may have with this practice is that sometimes your totals may not appear to add up. In the above example, if we have three cells with amounts of 5,250,760.95 and total them, the total will show 15,752. This total appears to be wrong, but the fact is that the underlying values of those three cells add to 15,752,282.85, which when rounded to the nearest thousand is 15,752.

If this is a problem for you, you will either have to re-enter the values in your worksheet as thousands (i.e. 5,251 instead of 5,250,760.95) or may get away with using the Round function in some of your formulas. =ROUND(formula,-3)

There are tens of millions of other Microsoft Excel users all over the world. The vast majority of them have a very limited knowledge of Excel's capabilities. My goal is to share this information with everyone I possibly can and help them to benefit from Excel's amazing capabilities.

Please help me spread the word about my newsletter. If you know other Excel users, please tell them about "Spreadsheet Tips From An Excel Addict". I'm sure they'll appreciate it.

Maybe you know someone who supervises or employs many Excel users. That's where your referral could have a big impact.

VERY IMPORTANT: Please refer only people you know personally, who use Microsoft Excel and would benefit from this newsletter.

Next time you are downloading a large file from the web, instead of sitting around twiddling your thumbs while it downloads, press CTRL+N to open a new browser window. Now you can surf away on the Internet as you are waiting for the download to complete. Sure this may slow the downloading a little, but at least you won't be bored.