On Mar 10, 11:46*am, "Sandy Mann" wrote:
Does the user who entered the date have "Transition Formula Entry" checked
in Tools Options Transition?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

wrote in message

...



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 the users in our group all have that item unchecked. Should we
have it checked?