Cannot get date format I want

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

Sandy Mann

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
 
S

Sandy Mann

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

why i cannot change a certain date format 1
Access Running Balance in Access 1
Format date in a cell 2
Start and End date 2
Bi-weekly date formatting 2
Averaging Month & weekdays 4
general date to date format 3
Changing The Day 1

Top