View Single Post
  #1   Report Post  
deniseh
 
Posts: n/a
Default CHANGE TEXT TO DATE FORMAT

Hi, I wonder if you would help me? I have to import a file from our accounts
package in .csv format into Excel on a daily basis. This works well apart
from the date which appears as, say, 20050901. I should like it to be
01/09/2005 or similar. I have tried formatting the column into date but
nothing seems to work correctly for me. Is there an easy way of converting a
column to the correct format please?
Thanks for your time.
Denise