Cannot get date format I want
 

I have an existing Excel spreadsheet that I have been using a date in for a
very long time. The format I use is ie 03/01/08. I drag across the row and
get the next date for the next columns for the entire month. I have
encountered a problem that now when I type a date in the cell instead of
getting 03/01/08 I get 01/0/1900. I have tried reformatting using the format
drop-down but cannot get it to go back to the normal format. Can anyone help
me?

Cannot get date format I want
 

Tools Options Transition Make sure no Transition option is checked

--
HTH

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


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


"mj" wrote in message
...
I have an existing Excel spreadsheet that I have been using a date in for a
very long time. The format I use is ie 03/01/08. I drag across the row and
get the next date for the next columns for the entire month. I have
encountered a problem that now when I type a date in the cell instead of
getting 03/01/08 I get 01/0/1900. I have tried reformatting using the
format
drop-down but cannot get it to go back to the normal format. Can anyone
help
me?

Cannot get date format I want
 

Thanks, Sandy. That did it!

"mj" wrote:

I have an existing Excel spreadsheet that I have been using a date in for a
very long time. The format I use is ie 03/01/08. I drag across the row and
get the next date for the next columns for the entire month. I have
encountered a problem that now when I type a date in the cell instead of
getting 03/01/08 I get 01/0/1900. I have tried reformatting using the format
drop-down but cannot get it to go back to the normal format. Can anyone help
me?

Cannot get date format I want
 

Glad to help. Thanks for the feedback

--

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


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


"mj" wrote in message
...
Thanks, Sandy. That did it!

"mj" wrote:

I have an existing Excel spreadsheet that I have been using a date in for
a
very long time. The format I use is ie 03/01/08. I drag across the row
and
get the next date for the next columns for the entire month. I have
encountered a problem that now when I type a date in the cell instead of
getting 03/01/08 I get 01/0/1900. I have tried reformatting using the
format
drop-down but cannot get it to go back to the normal format. Can anyone
help
me?