automatic date formatting

T

Terry Freedman

Hi
When I import data from a survey into excel, it automatically converts
a column containing age ranges to dates. EG, it converts 5-7 to 5th
July. Is there any way to prevent this happening please?

Thanks
Terry
 
S

Stephen

Terry Freedman said:
Hi
When I import data from a survey into excel, it automatically converts
a column containing age ranges to dates. EG, it converts 5-7 to 5th
July. Is there any way to prevent this happening please?

Thanks
Terry
Click to expand...

Format the column as text BEFORE importing.
 
Top