Klartigue
11-29-2011, 01:32 PM
In excel, i have dates in column B that are not separated by / /. For example, dates are just listed as:
1312003 -- I would like to write a macro to get this to say 1/31/2003
8312002 -- " " 8/31/2002
10312002 -- " " 10/31/2002
Is there any way can incorporate something in my macro that will look in column B and be able to separate this numbers into date form? Also, I would like to do this for all values in column B, which could range from B1:B100 or B1:B1380, etc..
Thanks for the help
1312003 -- I would like to write a macro to get this to say 1/31/2003
8312002 -- " " 8/31/2002
10312002 -- " " 10/31/2002
Is there any way can incorporate something in my macro that will look in column B and be able to separate this numbers into date form? Also, I would like to do this for all values in column B, which could range from B1:B100 or B1:B1380, etc..
Thanks for the help