I've created 300 files none of which show in the "preview-screen" when I do a File Open. The setting of course is in the File Properties, Summay Tab (chk box...

I'm wanting to have cells take the value of the last one updated across worksheets. I've found the code that accomplishs this within one worksheet, but not...

how would i seperate the data below (which is currently in one column) into two seperate columns based on date/time? 2/16/2005 1:09:09 PM

I'm using the Loan Calculator (Amortization Schedule) that comes with Microsoft Excel (I'm running Excel XP). I need to change it so that it will allow more...

From WITHIN Excel, I would like to import data from an MS Project file. I do not want to perform an explicit open on the project file and assume that there is...

How do I cacluate the Compound Annual Growth Rate from 1 number to another number over 5 years?

Trying to do some vlookup equations... they are working fine, but they only bring over the value, not the formating. In the particular problem I'm working on,...

I want to be able to take all or most of my special entries in the auto correct structure, and use them on a different machine without having to enter them all...

I want to use the same name, month9, to refer the same range of cells, but on different sheets, how do i turn off the global define?

I have recently updated my office 2003 package after a crash in word document. Now I can not get to open the attachments in particular the EXCEL attachment....

I have a spreadsheet that has many columns, some of which I am trying to sort by. One Column is called Closed Date, and is in Date Format. Another column is...

There are many occassions when I search my spreadsheet for multiple occurence of a particular number using the "Find All" search request. I then have to write...

I have recently upgrade from Office XP to Office 2003. I'm running XP Pro w/SP2 and all of the updates for Windows and Office. Here is the problem...

I'm trying to display 16 digit numbers in excel but it keeps converting the last digit to a zero. Is there a way to format the cells so the 16 digits...

Hello all, I have been having some serious issues trying to find a way to make Excel print two worksheets at the same time (one is in portrait and the other is...

Each time I open an existing file in Excel, the "Reviewing" toolbar shows up as a second rown of menu options at the top of my worksheet. I rarely use this...

I have a macro that selects all worksheets in a book and undertakes formatting for them. Is there a way that I can specify in the loop to select all sheets...

I would like to overscore a character within a cell in an Excell spreadsheet. I am able to add a Equation box with an overscore (insert object,...

Can anyone help me to calculate the minus figures only in a range of random costs? example £-2000.00 £ 1000.00 £ 560.00 £-4500.00 £-6500.00

Have just installed excel 2003 on a new PC, whenever a workbook is changed and saved, a file is created in the same folder which opens in excel as the same...