Hi there,
Could someone please help me in converting the date format DD-MMM-YYYY to DD/MM/YYYY?
I've tried using text to column, followed by the logical if function, then proceedding with concatenating but it doesn't work as I think I'm limited to a certain amount of logical test.
This is what I've done:
Current format:
11-MAY-2009
Text to column gives:
11
MAY
2009
Then proceeding with the logical Test:
=IF(B2="JAN";"01";IF(B2="FEB";"02";IF(B2="MAR";"03";IF(B2="AVR";"04";IF(B2="MAY";"05";IF(B2="JUN";"06";IF(B2="JUL";"7";IF(B2="AUG";"8";"00"))))))))
And finallt concatenating gives:
=A2&"/"&D2&"/"&C2 --> 11/05/2009
but I'm limited with the logical test
Any other alternative?
Thanks,
Jeremie Henry