On Mar 10, 11:34*am, cht13er wrote:
Is that one user using Excel 2007, and the rest of you something
older?

C

On Mar 10, 11:18*am, wrote:



Hi,

Thansk for your help.

My group here administers asharedworkbookthat 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 thesharedworkbookwill 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 thisworkbookfor years without incident. *Don't
know why this just started happening now.- Hide quoted text -

- Show quoted text -

No. We are all on the same Excel platform which si Excel 2003.
Thanks though..