How to convert text to date
Closed
outofmyleague
-
Oct 15, 2009 at 11:35 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 15, 2009 at 08:33 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 15, 2009 at 08:33 PM
Related:
- How to convert text to date
- Convert m3u to mp3 - Guide
- Convert picture to shape powerpoint - Guide
- How to convert number to words in word - Guide
- Youtube to mp3con converter - Download - Music downloads
- Convert dts to ac3 mkvtoolnix - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 15, 2009 at 08:33 PM
Oct 15, 2009 at 08:33 PM
I do not know how the data is entered.
select a date cell and see the formula bar.
if it is m/d/yyyy
then the date is entered correctly. You can format in any form using format numbmer -date.
If the formula bar also shows 90102 then you have to use a formula
I hope this dates is 2nd January 2009 then in that case in another empty cell copy this formula
=(MID(A1,2,2)&"/"&RIGHT(A1,2)&"/0"&LEFT(A1,1))+0
now you format the new entry as any DATE format.
if you carefully study the formula you can do similar formulas in the future
when you use mid, left or right it becomes a text . to convert this into number you use that zero (0) at the end .
select a date cell and see the formula bar.
if it is m/d/yyyy
then the date is entered correctly. You can format in any form using format numbmer -date.
If the formula bar also shows 90102 then you have to use a formula
I hope this dates is 2nd January 2009 then in that case in another empty cell copy this formula
=(MID(A1,2,2)&"/"&RIGHT(A1,2)&"/0"&LEFT(A1,1))+0
now you format the new entry as any DATE format.
if you carefully study the formula you can do similar formulas in the future
when you use mid, left or right it becomes a text . to convert this into number you use that zero (0) at the end .
