You are here:

I am happy to answer any questions about Microsoft Excel. If you have an Excel problem, let me help you with it. Also, please be sure to check the Microsoft Excel Tips & Tricks and Microsoft Excel Tutorials sections of my web site.
I have been using Microsoft Excel since the very early Windows 3.1 versions. I have been teaching Microsoft Excel in the classroom since 1994, and online through computer tutorials since 2002.
I have been volunteering on AllExperts in the categories of Microsoft Access, Visual Basic, and Weight Loss for years.
I have created a line of computer tutorials online at www.ExcelLearningZone.com and www.599CD.com/Excel.
Personally, I am self taught. I've learned everything I know from books and trial & error. If I don't know the answer, I know how to find it.
I have over 20,000 happy clients worldwide.
| User | Date | K | C | T | P | Comments |
|---|---|---|---|---|---|---|
| Richard | 11/03/09 | 10 | 10 | 10 | 10 | Thank you very much for your answer ..... |
| Monte | 11/02/09 | 10 | 10 | 10 | 10 | Thank you! The mistake I was making ..... |
| Jynnipher | 11/02/09 | 10 | 10 | 9 | 10 | |
| Alexander | 11/01/09 | 10 | 10 | 9 | 10 | |
| Alan | 10/27/09 | 10 | 10 | 10 | 10 | Thanks for this. I didn't know that ..... |
Well, I wouldn't try to merge them using Excel. I would merge them in Access. If you still have the original data in Access, then I would create a new table and then use an APPEND QUERY to merge all of
This tutorial should answer your question: There are many different techniques in Excel you can use to break apart dates or times into their component parts, add or subtract dates, and figure out how
You can't apply conditional formatting to a DIFFERENT cell without some VBA programming. Excel has a feature called Conditional Formatting that you can use to change the format (color, font, bold, etc
Excel has a feature called Conditional Formatting that you can use to change the format (color, font, bold, etc.) based on the value of the cell. See this FREE video tutorial on my web site for instructions
How about putting the actual date in column A, and then in column B you could say: =DAY(A1)*5 This would give you $5.00 for each day of the month, resetting back to $5 when you hit the first of next
Answers by Expert:

©2009 About.com, a part of The New York Times Company. All rights reserved.