bloubul
Member
Hi All
Can any one please help.
I need to format the date in excel from "yy/mm/dd" to "mm/dd/yy"
I have tried "mm/dd/yy;@", in custom format but to no avail, I need to format 7000 rows in column "A1:A7000".
Is there perhaps a macro that I can use, I have search on the Net but can't find any.
I thank you in advance.
BlouBul
Can any one please help.
I need to format the date in excel from "yy/mm/dd" to "mm/dd/yy"
I have tried "mm/dd/yy;@", in custom format but to no avail, I need to format 7000 rows in column "A1:A7000".
Is there perhaps a macro that I can use, I have search on the Net but can't find any.
I thank you in advance.
BlouBul