Hey,
Have a problem with my huge file with data. In column J I have dates, like 2010-10-13, but the format of the dates is text.
Do anyone know how to make a macro to convert the entire column J into date format, and should read "13-10-2010". If I go to each cell in column J, press F2 and enter, the field automatically changes to date format, but for 16000 rows, its gonna take me alot of time.
Brgds
Thomas
Have a problem with my huge file with data. In column J I have dates, like 2010-10-13, but the format of the dates is text.
Do anyone know how to make a macro to convert the entire column J into date format, and should read "13-10-2010". If I go to each cell in column J, press F2 and enter, the field automatically changes to date format, but for 16000 rows, its gonna take me alot of time.
Brgds
Thomas