I have a text file, in the first column I have dates in the format MM/DD/YYYY. When I open this file in Excel the first column looks bad: 8/31/2006 stays the...

ok, i have used a countif formula to work out how many days are accounted for!. now i want to create another formula where it adds up the days as well as adds...

In some cells, text appears as ###### and in other cells as the text itself. I want to control, how the text appears. Does anybody knows how can I do...

Is there a way to run a macro that hides/unhides multiple worksheets based on the value selected on a data validation list? If so, what would the VB syntax...

what formula is used when you enter a number into cell and it is round up to a multiple of 3. So if 20 is entered in a cell that it is changes it to 21. --...

This is a very fundamental question. If I have a worksheet (or a set of worksheets) containing a complicated calculation, how do I refer to this calculation...

Hi. I have a spreadsheet with almost 5000 rows with about 15 columns of data, 2 columns of which contain sentences, phrases, or paragraphs of comments...

I am trying to save four Excel workbooks as a Workspace. When I press the Save button I get an error message that says "This extension cannot be used with...

I hope there is an easy answer to my formula problem so I will try to explain the best that I can. I am trying to relate ranges of soil types to their...

There are three lists of numbers under column A,B,C Is there any build-in function to determine the stability within change? For example, 1 1 1 1 1 1 1 1 1 1...

I'm working on a spreadsheet that I need to give an additional amount showing an increase in the budget amount based on a 40% redemption of the budget. On...

I enter grades into Excel in an A-E format. I would like to create a number average, where A+=1, A=2, A-=3 etc, so that it picks up an A, B+ and C- average...

Hi, I am using Excel 2007. Each time I Close Excel I get an error box (Microsoft Office Excel has encountered a problem and needs to close. We are sorry for...

Hi, I am using Excel 2003 at work and I have a spreadsheet that contains data validation dropdown list. I need to edit my list to add co-workers. When I...

I have a column of cells that have excess data that needs removed. The #of characters vary. I'm needing a formula to delete all the characters that precede...

Hi Excel experts! I have 20 colums, each one is about 30 cells long, that are placed on the worksheet one next to the other. It takes me a lot of time to copy...

I need to gather information from multiple files that all have the same layout but different information. Is it possible to update this information into one...

I have created a worksheet at home on Excel 2007 using 'sumifs' and 'countifs' formulae and when I have saved this (in .xls format) and then opened it in...

I'm in a mail prg. and I desperately need to figure out how to make the cache permament! Please help!

I’m using the below macro to copy a group of cells to another sheet, but I’m getting an error message. Can someone help me figure out what is wrong with...