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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
This is just a guess
highlight the cell and click Edit-clear-all
now tyope "sept 28"
any improvemnet
=====================
 
Back
Top