Excel not recognizing date input

Dear Sir,

When I input the date in Excel like 20120919 without "/" and "-", the date is not recognized.

Is there any method can solve it?

Thanks,
Wataw
WatawAsked:
Who is Participating?
 
krishnakrkcConnect With a Mentor Commented:
Custom format the cell as 0000-00-00

or use

=TEXT(A1,"0000\-00\-00")

Kris
0
 
Michael FowlerSolutions ConsultantCommented:
You could format the cells as customer format "yyyymmdd" and then enter the date like 19/09/2012 and excel will display it in the correct format

Michael
0
 
WatawAuthor Commented:
Dear Kris,

Thanks. It's works. I can input the date without enter the "/" or "-" now.

With regards,
Wataw
0
All Courses

From novice to tech pro — start learning today.