Previous Topic Next Topic

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
Related:

5 responses

Answer 1 / 5
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
Answer 2 / 5
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
Answer 3 / 5
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
Answer 4 / 5
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
Answer 5 / 5
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How can I publish a study that I have done on this website?
simonrasho -
Daniel_CCM -

1 response
Unsupported signal. Please check device output
S.Agnew -
Yaya68 -

14 responses
Problem connecting certain websites
PaulZero -
Anonymous -

90 responses
How do i change date format in (dd.mm.yyyy)
Talha -
Catherine -

6 responses