Cant format date in excell

Solved/Closed
matia93
Posts
3
Registration date
Wednesday August 14, 2013
Status
Member
Last seen
August 14, 2013
- Aug 14, 2013 at 01:19 AM
imran123
Posts
10
Registration date
Wednesday August 14, 2013
Status
Member
Last seen
August 16, 2013
- Aug 15, 2013 at 12:42 AM
Hi,

When I enter the dates as number with out forward slashes, and format them by right clicking on format cells and choosing date the date appears with strange numbers like years 2036.

Could you help me ?

Thanks

5 replies

imran123
Posts
10
Registration date
Wednesday August 14, 2013
Status
Member
Last seen
August 16, 2013

Aug 14, 2013 at 03:22 AM
Can u plz expln me in detail wat exactly the issue is?
0
matia93
Posts
3
Registration date
Wednesday August 14, 2013
Status
Member
Last seen
August 14, 2013

Aug 14, 2013 at 05:04 AM
Hey there what happens is when I enter 120212 I right click and choose format cells and the select date choose the first one and then the date 15/02/2229 comes up. Do I need to place symbols between each number ?
0
imran123
Posts
10
Registration date
Wednesday August 14, 2013
Status
Member
Last seen
August 16, 2013

Aug 14, 2013 at 07:34 AM
It should not happen like that but can u please check in Data Validation under Data tab that the validation criteria has been set to by default any value instead of another if not thn set it to any value.

Think it should work.
"A journey of a thousand miles begins with a single step."
0
matia93
Posts
3
Registration date
Wednesday August 14, 2013
Status
Member
Last seen
August 14, 2013

Aug 14, 2013 at 09:46 PM
Thank you I tried the data valuation and it was already set at any value. When I enter the date 120212 and format it I get 15/02/2229. Thanks again
0

Didn't find the answer you are looking for?

Ask a question
imran123
Posts
10
Registration date
Wednesday August 14, 2013
Status
Member
Last seen
August 16, 2013

Aug 15, 2013 at 12:42 AM
No problem dude. Enjoy!!!
0