Hi, I have a table with cells that have conditional formats. If one condition is met then that cell become red. Not all cells are red on a column. I want to...

I have a spredsheet to a few columns and one of the field is check numbers. This column looks like this: Check # 101 102 103 106 107 109 110 ....

I HAVE TRIED TO DO FORMAT, CELLS, ALIGNMENT & WRAP TEXT...IT DOES NOT WORK. I'M TRYING TO DO THIS IN A CELL THAT HAS BEEN MERGED WITH THREE OTHER CELLS TO THE...

I wonder if anyone can reproduce the following: 1. Create a new Excel workbook, select cell A1 on sheet1. 2. In menu Format/Cells/Alignment select...

I would like to be able to caculate working time when the cell format is 4/1/2005 6:40:26 AM (not seperated into date and time) Cell A1 dd/mm/yyyy h:mm:ss ...

First, much thanks to all the great people who have helped me so far . . . Tom Ogilvy, Dave Peterson, Frank Kabel among others . . . : ) I am considering...

I have a standard TAB delimited text file that I need to import into a worksheet. This file is generated by another application and I simply want to load the...

I need to come up with a formula that will result in Good or Busted The racers speed must be within 1.25% (+ or -) of the speed entered into the equation...

I have a list of data in a different worksheet, and if I use vlookup ie. =VLOOKUP(AA4,'Dump'!$A$1:$DB$151,91,FALSE) - It brings back a value, however if I...

How do you set computer to print "freeze panes" on succeeding pages in excell?

When copying a medium to large group of cells, the above message is received as a popup. No error id - just the message in a popup window. Incredibly...

I know how to change a file location in Excel for the default location on the general tab. My problem is that location no longer exists, so I need to change...

I don't know if I should have started a new thread for this question, but in fact for some reason I can't get any response by clicking on 'New' anyway, so I...

I am located in Australia and my PC Regional Option is set as dd/mm/yyyy short date format. I receive reports from a US based system that generates an Excel...

I am experiencing something strange. I often have to VLOOKUP on worksheets containing around 10 000 rows. VLOOKUP work well but after that, when I try to do a...

I just installed Office 2003 and transfered excel files from the older version. The comments that I had created before I moved to 2003 look fine in the default...

Hi there...I am new here. I am looking for some help. I thought I knew how to use excel with many nested ifs and such but then I tried doing this one!! When...

I have a problem that has been frustrating me for a while. I have built a number of workbooks that use Pivot Tables with an Analysis Server data source. When...

I have a spreadsheet for my staff where they log their time against every job they do. Each member of staff has their own work sheet where they enter this...

Recently, while trying to create a calendar in Excel (I realize that there are better ways), I was using a formula to get the calendar to display the date. I...