Cant format date in excell
Solved/Closed
matia93
imran123
- Posts
- 3
- Registration date
- Wednesday August 14, 2013
- Status
- Member
- Last seen
- August 14, 2013
imran123
- Posts
- 10
- Registration date
- Wednesday August 14, 2013
- Status
- Member
- Last seen
- August 16, 2013
Related:
- Cant format date in excell
- How to format date in excel - Guide
- Conditional formatting dates in excel - Guide
- Date format change in excel ✓ - Forum - Excel
- Format data in excel for Db transaction ✓ - Forum - Excel
- Unable to format date in excel ✓ - Forum - Excel
5 replies
imran123
Aug 14, 2013 at 03:22 AM
- 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?
matia93
Aug 14, 2013 at 05:04 AM
- 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 ?
imran123
Aug 14, 2013 at 07:34 AM
- 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."
Think it should work.
"A journey of a thousand miles begins with a single step."
matia93
Aug 14, 2013 at 09:46 PM
- 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
Didn't find the answer you are looking for?
Ask a question
imran123
Aug 15, 2013 at 12:42 AM
- 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!!!