Cannot get date format I want

  • Thread starter Thread starter mj
  • Start date Start date
M

mj

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?
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Glad to help. Thanks for the feedback

--

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top