Sean forgot one step. Right click, select Paste Special..., Multiply and OK
out.

Regards,
Fred.

"Meenie" wrote in message
...
hmmm when I highlight the column and right click, "multiply" isn't an
option
in the box that opens up.

"Sean Timmons" wrote:

Sounds like the cells have been hard formatted for you. Easiest way to
fix is
to type 1 into a blank cell. Copy that 1, highlight your date column,
right
click, select multiply and hit ok. This should chnage them to the values
instead...

"Meenie" wrote:

I have Excel 2003.
I have a list of Meetings that my 2 bosses attend.
I have one list that lists all the meetings and is alphabatized.
Then I have another sheet in the same workbook that lists the meetings
for
each boss individually that has more info (ie: names of people
attending if
the boss is running the meeting - for emailing invites, minutes, etc,
also
info if the meeting changes meeting places on different dates - same
place
not always available every month)
I have these columns:
Meeting Date Time Contact name Contact Number Who attends Room

Under "date" it usually says something like "2nd Monday each Month"

I wanted to link from the main page of all meetings to each bosses
meetings
so if the date or time changed, it would change on their page also but
here's
what happened:
I linked from the main page of all meetings to each bosses page under
"date" simply by entering an equal sign on the bosses page and then
clicking
on the main page under date for each meeting. This worked fine unless
there
was an actual date in the cell (instead of text - like 1st Monday each
month). If there was an actual date, then in the bosses sheet the link
would
be written out instead of the info from the first sheet. (example:
='Recurring Mtgs Alphabetized'!B37:C37)

I also wanted to link the times, but they do the same thing.

Why can't I link to a date or time?
Thanks ... Meenie