Hi,

Thansk for your help.

My group here administers a shared workbook that calculates a whole
bunch of things for a portfolio of assets. The core of the infromation
is a log of all activity in the protfolio (Buys, Sales, Repayments,
etc.) We log this information by date.

We are having a problem here in that one person will enter a date for
some piece of activity as, say, 3/10/2008, and saves, but all the
other users on the shared workbook will see "1/0/1900" in that cell
where 3/10/2008 was entered. I can't figure out why this is
happening. I made sure they weren't entering it with a "=" sign and I
set formatting to "3/10/08" without the asterisk. Nothing seems to
work.

We've also been using this workbook for years without incident. Don't
know why this just started happening now.