In an un-used cell enter:

=TODAY()

if this is not the correct date, then touch CNTRL-ALT-F9 on the keyboard

post what happens.
--
Gary''s Student


"Kmagg" wrote:

We have a spreadsheet that we want to enter a date in a cell. I have changed
the format to Date 03/01/01 format but no matter what I do, any date is
converted to 01/01/00. I have tried inserting a column, copying to another
spreadsheet, etc. I know this is probably simple, but it's driving me crazy.
Help please.