Excel 2000, 2002, 2003, 2007 Tips

The Excel Addict - Help with Excel 2007

Publication Date: May 19, 2010

This newsletter is being sent to 15,000+ Excel 'addicts' around the world
using Aweber, the best solution for managing your email campaigns.  

If you having trouble displaying graphics in this email, I have
posted an online HTML version of this week's newsletter here.

Greetings from The Excel Addict

Hi fellow Excel Addict,

Francis Hayes (The Excel Addict)I hope you are enjoying a great week. Are you someone who loves to take it easy and relax or are you someone who feels alive when you're busy, busy, busy?

I've inherited my mother's 'never slow down' trait. It's been a hectic week here, with my wife and I doing major interior house renovations (that originally started out as just painting our bedroom), the roofers working on my roof, playoff hockey games almost every night, oh yes, and my day job.

With the terrible weather we've had here for the past few weeks, my lawn is long overdue for it's first mowing of the year and the flower beds are begging for some attention. But alas, a long weekend is coming up and if the weather cooperates, I hope to make some meaningful progress with my to-do list..

I'm just glad I had some help getting my newsletter finished this week. Every week my cat helps me with my newsletter. She is a very good editor and had some great suggestions for this weeks tips. Her paws are all over it.

I hope you enjoy them.

To your SUCCESS !
Francis Hayes (The Excel Addict)

If you want to send me an email...

• Please type 'The Excel Addict' in the Subject field of your emails.
• If you reply to this email, please delete the newsletter content before Sending.
• Remove background color in Outlook 2007 - Options, Page Color, No Color.

View The Excel Addict Francis J Hayes's profile on LinkedIn   Find out what The Excel Addict is doing NOW

This week's tips..

1) Quickly Convert Dates To Numbers Or Numbers To Dates (XL2000-XL2007)
2) Sort Dates By Month And Day (Ignoring Year) (XL2003/XL2007)
3) Definitions By Google

If you're having trouble displaying graphics in this email, I have posted an online HTML version of this week's newsletter here.

Last week's tips were...
1) Automatically Flag Duplicate Values On Input (XL2000-XL2007)
2) Bring Back The 'Center Across Selection' Tool (XL2000-XL2007)
3) What Time Is It There?

You can still find last week's newsletter here.

You can access even more tips on my website by going to my members' page.  


A quote from my cat"You have brains in your head. You have feet in your shoes. You can steer yourself any direction you choose. You're on your own. And you know what you know. And YOU are the one who'll decide where to go..." -- Dr. Seuss (Oh, the Places You'll Go!)

CAUTION: Make sure you save a copy of your spreadsheet before trying these tips,
just in
case you make an error or the procedure doesn't produce the results you want.

Microsoft Excel Tip #1

Quickly Convert Dates To Numbers Or Numbers To Dates (XL2000-XL2007)

Sometimes when you type a number in a cell next to a date, Excel assumes that you are entering another date and automatically formats the number as a date. To quickly change the date back to a number, select the cells and press CTRL+SHIFT+~

On the other hand, you may have imported data from another file and the dates are displaying as numbers. You can quickly change the numbers to date formats by selecting the cells and pressing CTRL+SHIFT+#

These are two keyboard shortcuts I use almost every day.

Microsoft Excel Tip #2

Sort Dates By Month And Day (Ignoring Year) (XL2003/XL2007)

There may be times when you would want to sort dates by month and day while ignoring the year, such as grouping anniversary dates (e.g. clients, birthdays, etc...).

By default, when you sort dates in a column they are sorted by year, month and day. If there are dates from multiple years and you want your data arranged by month, there is no obvious solution.

Here's the work-around solution I use. There are are other ways to do this (as is the case with most things in Excel) but this one is quick and simple...

1) Insert a blank column;
2) Assuming your first date is in cell A4, in the blank column, enter the formula =TEXT(A4,"MMDD")
3) Copy this formula down to the bottom of your data;
5) Sort your data on this column.

Sort dates by month and day in Excel

101 Excel Tips revealed in this book
Microsoft Excel 2000 - 2003

Try out the secrets in my ebook for two months. If they don't save you 10 times the price of the book...

If you're not 100% satisfied...

...simply request a full refund from ClickBank.com

There's absolutely no risk to you.

Non-Excel Tip

Definitions By Google

As you may have noticed, I'm a big Google fan.
Need a quick definition while online? Go to Google and type "define", a colon and then the word you want a definition for. Google will retrieve definitions from various sites on the web.

Easily find definitions with Google
Easily find definitions with Google

My goal: To reach One Million Excel Users

Subscription Information

Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter.

If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber(DOT)com

If you would like to share this newsletter with others...

1) Forward this newsletter by email, but first delete the unsubscribe link at the very bottom so you don't get accidentally unsubscribed

2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber(DOT)com

3)  Post a link to TheExcelAddict.com in a company newsletter or website
"Spreadsheets Tips From An Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630