jag108
Active Member
- Joined
- May 14, 2002
- Messages
- 433
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Hi
I need to convert this text string into a standard date fromat.
each cell is formatted like "4 Mar 2007 Su" I need it to be 20070304
I have managed to seperate out the different parts i.e.
04 = day_val
"Mar" = month_val
2007 = year_val
But I am having the most difficult time getting them back to the date format mentined.
I have about 1700 entries that will need to be converted.
I need to convert this text string into a standard date fromat.
each cell is formatted like "4 Mar 2007 Su" I need it to be 20070304
I have managed to seperate out the different parts i.e.
04 = day_val
"Mar" = month_val
2007 = year_val
But I am having the most difficult time getting them back to the date format mentined.
I have about 1700 entries that will need to be converted.