ExcelBanter - automatic date formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - automatic date formatting (https://www.excelbanter.com/excel-discussion-misc-queries/164195-automatic-date-formatting.html)

Terry Freedman

automatic date formatting

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

Stephen[_2_]

automatic date formatting

"Terry Freedman" wrote in message
ups.com...
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

Format the column as text BEFORE importing.

All times are GMT +1. The time now is 04:13 AM.