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

Reverse Index Match 2
Conditional format Column based on Week Date 2
How to add day to PWA 2016 date format? 0
Check if a date comes before/after a range of dates 0
Format date in a cell 4
Bi-weekly date formatting 2
Excel does not accept text format! 0
why i cannot change a certain date format 1

Top