Convert a numeric string to date, month, year
Closed
pablo
-
Oct 26, 2009 at 03:20 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 26, 2009 at 09:43 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 26, 2009 at 09:43 PM
Related:
- Convert a numeric string to date, month, year
- Convert m3u to mp3 - Guide
- Convert picture to shape powerpoint - Guide
- How to convert free fire id facebook to google - Guide
- Convert dts to ac3 mkvtoolnix - Guide
- How to convert numeric to words in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 26, 2009 at 09:43 PM
Oct 26, 2009 at 09:43 PM
suppose the entry is in A1
if necessary format this to a date
=(MID(A1,5,2)&"/"&MID(A1,7,2)&"/"&LEFT(A1,4))+0
if necessary format this to a date