Hi,

Well, not exactly:

1) semi-manual - select the cell in question and hit Alt+;(semicolon)

2) Using VBA code assocviated with the Change event of the worksheet. Let us
know if you need help putting it together and obviously a bit more of detail
regarding the setup of your sheet..

Regards,
KL


"Lewis Koh" <[email protected]> wrote in
message news:[email protected]...
>
> so there is no way of fixing the date to the date I key in "A1" other
> than typing the fix date manually?
>
>
> --
> Lewis Koh
> ------------------------------------------------------------------------
> Lewis Koh's Profile:
> http://www.excelforum.com/member.php...o&userid=25712
> View this thread: http://www.excelforum.com/showthread...hreadid=391511
>