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