Does anyone know of a way to sort a list by the cell format or by the text format? I have a very long list where the 'good' cells have been colored in yellow....

How do I get the gridlines to print in my word document using XP?

if it is formatted as text, it should not strip off the leading 0. -----Original Message----- I have 4 colums a,b,c,d I use A1&" "&B1&", "&C1 in colum d...

Hi Guys, I have had excel 2002 before and just picked up 2003 and in my excel sheets scrolling is very slow whenever i scrolling in an empty or full...

I want a formula to do this if c2 = Holiday or Bank Hol then display 8 (in the cell im typing the formula) if not do another formula (on the info in c2)

I have an excel report that needs to be fed from an excel database. The best function I found was vlookup. However, vlookup only capture the result of one...

Does any one know how to get a value from one worksheet to put in another. for example on sheet 2 would be 3 columns. the values in the first 2 columns would...

What ever happened to the Autosum button? Is this no longer availl in excel 2000?

Nevermind, got it

What a waste of everybody's time -----Original Message----- EXCELLENT CASH INCOME I started out with $6. Now, I am making thousands. I found...

Ok, I've filtered my spreadsheet using AutoFilter and selecting one of the availble cell contents as a criteria. Now that I've got a table that shows only the...

I have a spreadsheet that is updated by multiple users. When they enter their names they enter it in the format (first_name Last_name). Does anyone know how I...

NO more new fonts may be applied to this workbook

How do I get the highest number from a column?

I've got a data set with two columns that I'd like to summarize by COUNT and SUM. eg. Status Variance NP $(50,000) P $ 25,000 P ...

i'm trying to write for a formula that will give a 0 (zero) value rather than "#DIV/0!" when 2 zero values are divided by each other. i tried to use the "IF"...

Let me clarify. I am trying to transfer data from an excel 2002 cell to a specific place in a word 2002 document. I am not trying to cut/copy and paste. I...

I'm looking for a way to look up/return a value based on 2 nubers like below: I need the balance for Account 57500, & Cost Center 125 from a trial balance...

hi! I am not sure if this is possible. i want to custom format a cell in the form of "R1 SB-1 1" when "1B11" is entered. this is because the letter 'B' will...

I'm using the folowing formula to locate a specific cell and return the value in that cell based on matching 2 different values to values in cells to the side...