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
imran123 Posts 10 Registration date Wednesday August 14, 2013 Status Member Last seen August 16, 2013 - Aug 15, 2013 at 12:42 AM
Related:
- Cant format date in excell
- How to change date format in excel - Guide
- Marksheet format in excel - Guide
- Format factory - Download - Other
- Kingston format utility - Download - Storage
- Samsung format code - Guide
5 responses
imran123
Posts
10
Registration date
Wednesday August 14, 2013
Status
Member
Last seen
August 16, 2013
Aug 14, 2013 at 03:22 AM
Aug 14, 2013 at 03:22 AM
Can u plz expln me in detail wat exactly the issue is?
matia93
Posts
3
Registration date
Wednesday August 14, 2013
Status
Member
Last seen
August 14, 2013
Aug 14, 2013 at 05:04 AM
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 ?
imran123
Posts
10
Registration date
Wednesday August 14, 2013
Status
Member
Last seen
August 16, 2013
Aug 14, 2013 at 07:34 AM
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."
Think it should work.
"A journey of a thousand miles begins with a single step."
matia93
Posts
3
Registration date
Wednesday August 14, 2013
Status
Member
Last seen
August 14, 2013
Aug 14, 2013 at 09:46 PM
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
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
Aug 15, 2013 at 12:42 AM
No problem dude. Enjoy!!!
