I have several workbooks with date-formatted cells that work properly.   I
just created a new one, however, that will not display properly.  I have
tried several "date" settings and also the "custom, d-mmm-yy" setting, yet
information placed in the cells come up as a date in "Jan ...

I have a need to select and store unique cell contents in a large number of
rows.  I guess I would like a formula that looks something like
=unique(a2:a22,","," ") where the information I would to test is in cells a2
through a22, seperate the contents of the unique cell contents, ...

Version - Microsoft office 2003 - Just a regular spreadsheet with data.  I
have clicked into one of the cells & im trying to add a pivot table however
when I go to select it it is greyed out as in not an option to select?

A long time ago I had some code to add a drop down menu to Excel. Can some
kind soul please direct me to a location where I can recapture that
code.\Thanks

Here is what I want to do:
If a cell (formatted as number) is between 0 and 10 multiply it by this.  If
it's between 10 and 20 multiply it by that.  How do you write that?
thx

I have a set of about 50 source files, each with 5 named ranges (one
name range on each of 5 tabs).  I am trying to create a macro to copy
the named ranges for each of the source files to the corresponding tab
of a destination file so that the destination file contains a column

I've got a spreadsheet with a number of columns and I could do with putting a
subtotal into a column in the middle of the data. Currently the columns are:
Charged - Location - Size - Item
Every line in my source data has a value in the Size column which is the

I am trying to create a 24-hour staffing schedule but I cannot figure out how
to automate the process.
There are 7 overlapping 12-hour shifts with two work groups A & B.  A works
3 12 hour days with 4 off then works 4 12-hour days with 3 days off.  B works

i am very very new to excel and i have created a report that has some
formulas in it..everything looks good. so i print it.
when i reopen the report a box comes up and has three little square that say
 Update....Dont Update...Cancel....doesnt matter if i pick dont update or

Not sure if I worded that correctly. Here's what I need to do: I have sales
data for a month that is listed individually by date and item number. I need
to go through the entire workbook and find each occurance of each item and
add together the number of items ordered. Here is an ...

I need an automatic formula or a format that give's me the ability to enter
these numbers (Handling Time) as (HH:MM)
but to be converted to fractions (example:  00:30 should be displayed as
0.50, as 00:30 is 50% of an hour)

How do I check if the content in a cell, when divided by 4, returns an
integer? It should give me 150 if it is an integer and display "NA" if it is
not an integer.
For example, the formula should check if the content A2 divided by 4 is an

Office97 - Excel97 - XP SP2
I did something to make my .xls files disappear.
They're all there.
I can see them with Explorer.

I have a excel file a fairly large database in one sheet and another sheet
for pivot tables from that databse. once the pivot tables  are loaded the
capacity jumps from a mere 175 or 200 kb to 9 or 10 mb. and gives me
difficulties in saving the file in network drives. how can i ...

I need an automatic formula or a format that give's me the ability to enter
these numbers (Handling Time) as (HH:MM)
but to be converted to fractions (example:  00:30 should be displayed as
0.50, as 00:30 is 50% of an hour)