Excel Date reads the days as the year. Whats wrong?

G

Guest

For some strange reason, when i type in the date to be automatically
formatted in the chosen format (mmm dd/yyyy) the output puts the day as the
last 2 digits of the year and the day is always the first of the month - ie
"sept 28" reads Sep 1/2028. What is wrong here?
 
G

Guest

This is just a guess
highlight the cell and click Edit-clear-all
now tyope "sept 28"
any improvemnet
=====================
 

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

Top