sorry, you need to hit "Ctrl+;" (not Alt+ in the first solution.

KL


"KL" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>
>