Hi again,

Am Tue, 28 Oct 2014 08:32:37 -0700 (PDT) schrieb michaelberrier:

This originally started when I imported a workbook of survey data with a column representing years of experience. Some of the options were "1-3", 3-5", etc. For every one of those that could be translated into a date (1/3/2014), the spreadsheet automatically did that. Is there a way to stop Excel from doing that so I don't have to make this fix in the first place?

format the expected column as text before importing the data.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional