software

I use Query to pull in data from several separate excel spreadsheets at once
for data mining. Recently I've come across a query in which no data is

Have the following equation:

Good Day,

I use Excell on 2005 and 97 and had no trouble using the custom format
hh:mm:ss.00 to enter times to the hundredth. I use this to calculat ET for

Excel 2003 shows a filter arrow on data rows, to select/deselect single items.
Can I apply custom settings as you can on Autofilter?

I have a worksheet with 4 columns and about 600 rows. The A,B,C columns have
contents in all their cells. Only a few cells have contents in Column D. What

How can i change the cell from this (#REF) to this (0.00) or can i just hide
this ref.

I am using excel 2003 and we got like a very big worksheet on one file. I
just wondering if ther is any limitation on how many dropdown ( to sort

I want to put a sheet for every week of the year (52) and have it total the
sales at the end of each month and then at the end of the year.

Hi people,