Trying to convert a column of data into date format in Excel
Posted on 2011-09-20
I exported data from a program which I have openned in excel. The date and times have added an " ' " symbol. Specifically, in the date column, the data I have in the columns is:
In the time column (different column), the data I have is:
I know if I remove the " ' " character, excel is able to recognise the data as a time / date format. However, I tried functions in excel which removes the first character in a cell but that does not seem to work.
Any advice is greatly appreciated