Convert date

[martinez_pedro]

Hi does anyone has a macro that can convert this date 1110401
to this one 04/01/11
thanks for you help

[jwright650]

Are you sure the raw date has 7 digits and the expected date has 6 digits?

[martinez_pedro]

Yes it is 7 it always come this way i don't know why they add the number 1 at the beginning of the string

[farrukh]

Hi martinez_pedro

Can you attached your sample excel file?

Thanks
Farrukh

[jwright650]

If we remove the "1" out of every date...I think we can deal with the format to get you what you need. How many rows in the date column do you typically have?

[martinez_pedro]

The number of row varies day by day it can be from 100 to 8000 at the end of the month is when i get the biggest one

[jwright650]

Not sure if you can use this or not....added a column "converted date"

[martinez_pedro]

hey that formula works perfectly THANK YOU
Here is what i did to make your formula into a macro

Please Login or Register  to view this content.