Excel MMYY format in order
Solved/Closed
nickkyh
Posts
3
Registration date
Monday February 24, 2014
Status
Member
Last seen
February 24, 2014
-
Feb 24, 2014 at 11:36 AM
nickkyh Posts 3 Registration date Monday February 24, 2014 Status Member Last seen February 24, 2014 - Feb 24, 2014 at 05:54 PM
nickkyh Posts 3 Registration date Monday February 24, 2014 Status Member Last seen February 24, 2014 - Feb 24, 2014 at 05:54 PM
Related:
- Excel MMYY format in order
- Excel date format dd.mm.yyyy - Guide
- Marksheet format in excel - Guide
- Format factory - Download - Other
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
5 responses
Ok, let us try this:
=DATE(RIGHT(A1,LEN(A1)-2)+100,LEFT(A1,LEN(A1)-2),1)
This assumes always 3 or 4 digit dates.
let me know!
"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
=DATE(RIGHT(A1,LEN(A1)-2)+100,LEFT(A1,LEN(A1)-2),1)
This assumes always 3 or 4 digit dates.
let me know!
"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
nickkyh
Posts
3
Registration date
Monday February 24, 2014
Status
Member
Last seen
February 24, 2014
1
Feb 24, 2014 at 12:41 PM
Feb 24, 2014 at 12:41 PM
Hey ac3mark,
Good shout and I have tried similar methods but if you try putting 909 for instance, I know its Sept 2009 but excel has other ideas, so =TEXT(A1,"YY-MM") for instance is apparently 02-06!
As I have a large amount of recurring data, manually changing it would not be ideal and seems no way of formatting the date when it is in that number form that I have tried so far.
Many thanks
nickkyh
Good shout and I have tried similar methods but if you try putting 909 for instance, I know its Sept 2009 but excel has other ideas, so =TEXT(A1,"YY-MM") for instance is apparently 02-06!
As I have a large amount of recurring data, manually changing it would not be ideal and seems no way of formatting the date when it is in that number form that I have tried so far.
Many thanks
nickkyh
Didn't find the answer you are looking for?
Ask a question
nickkyh
Posts
3
Registration date
Monday February 24, 2014
Status
Member
Last seen
February 24, 2014
1
Feb 24, 2014 at 05:54 PM
Feb 24, 2014 at 05:54 PM
That does the trick, thank you ac3mark, you are a gent and a scholar!
Dates sorted and problem solved:)
Dates sorted and problem solved:)
