Hi Fellow Excel Addict,

I hope you've been getting all my tips. With all the problems with Spam these days, many people are unknowingly having their email blocked before it even reaches their Inbox.

I'd appreciate if you'd send me a quick note to let me know that you have been getting my tips. I've also added a Contact Form to the main page of my website that you can use to send me a quick message.

This week I've got some tips that I know you are going to love. Try them out and let me know what you think.

Again, I always appreciate your help in sharing my newsletter with other Excel users.

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

P.S. Remember to include "TheExcelAddict" in the Subject line of any emails you send me. This will help them 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/

You are aware that Excel offers you a variety of font sizes that allow you to format your data the way you want. Common sizes are 8, 9, 10, 11, 12, 14, 16, 18, 20, 22, 24, 26, 28, 36, 48, and 72. How often have you tried one size which was a bit too small and the next size was a bit too big, so you ended up selecting the best one of the two?

You don't need to settle for second best. You can have whatever size you like if you know the secret.

To choose a font size other than those on the Font dropdown list, click to the left of the arrow, where the font size is shown, and enter whatever size you want (must be between 1 and 409). Then press Enter. There you have it, a perfect font size.

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 referral@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

Have you ever copied or imported data into Excel and realized that the date formats were all wrong. For example, your computer may recognize dates in dd/mm/yy format and you've just copied data, that includes a date column, from another source and the date format there is mm/dd/yy.

You'll notice that Excel recognizes some of the dates but for most it won't. You'll see the dates that Excel has recognized as right-aligned cells and those it didn't recognize, and assumed was text, as left-aligned cells. If you look closely you'll see that even the cells Excel did recognize as dates are wrong - the months and days are switched.

It can be quite a task to fix all of these dates. In the early days I tried various techniques to solve this problem, but all of them were time consuming. Then I discovered a simple little trick using Excel's 'Text to columns' option.

Here's what you can do...

1. Highlight the cells (only one column wide) containing the dates. You can select the entire column if you like.
2. From the Data menu, select 'Text to columns'
3. In the dialog box, select the 'Fixed width' option and click the Next button
4. If there are any column break lines (vertical lines with arrows) through the data area, double-click on them to remove them all. Then click the Next button
5. In the 'Column data format' section, select MDY from the Date dropdown. This tells Excel the format of the imported dates.
6. Click the Finish button.

Now, isn't that cool?

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.

Often it is necessary for you to work with more than one Window, such as copying information from your browser and pasting it into MS Word. If you find yourself switching back and forth between two Windows often, you may find that all this switching back and forth can be a bit of a pain.

Try this instead.

On the top right corner of each window there are three small buttons, Minimize, Restore/Maximize, and Close. The middle button either shows the Restore button (two small squares) or the Maximize button (one large square).

1. On the first window you want to work with, click the Restore button. If the restore button is not shown, go to step 2.
2. Click on the window header (blue bar on top of window) and drag its top left corner to the top left corner of the screen.
3. Move the cursor to the bottom right corner of the window and when it changes to a two-headed diagonal arrow, drag the corner of the window to resize it to fit half of the screen.
4. Now switch to the second window you want to work with and click its Restore button (if it is shown).
5. Resize the window, same as step 3
6. Click on the window header to drag and position the window immediately to the right of the first window.
7. At this point you may need to resize it again from the bottom right corner.

I'll bet you can think of many situations when this tip could come in real handy.