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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i stop excel from converting numbers entered into a date 2
text string: "91E10" in csv file auto converts to: "9.10E+11" 2
Need to open eer file without converting 8-7440 to a date? 1
import csv without automatic date conversion 1
Prevent excel from changing numeric data ranges into dates? 2
Stopping Excel from reformatting data as a date? 1
CSV->Excel Data Problem 1
Copying text gives me date value. 2

Top