lol - can see my replies now.

After a fair bit of searching (still not sure if i can use it for
ADO), there may be a way.
Make a copy of your csv file. (Just incase)
rename it from csv to txt
when you open it in excel, the Import text wizard should open.
click on the relevent columns and change them from general to text.

They should now stay as desired.

Hope this helps.
George

On 16 May, 17:46, Armando wrote:
" wrote:
The cells need to either be formatted as text before the import, or
the data entered with ' before it to represent text
eg '12-50 will display as 12.50 if typed in.

On 16 May, 00:42, Armando wrote:
This is probably a dumb question but I am having some trouble when importing
data into excel. Excel seems to be taking my data and formatting it
automatically. For example I have a field that asks how many users were
affected. Excel will take the answer of 1-10 and interpret it as Jan-10 or
data that is 12-50 and interpret it as Dec-50. Does anybody know how to stop
excel from doing this? Thanks in advance and sorry about the lame question.

Thanks for the response George. But the file that I have is saved as a CSV file so excel opens it automatically. This cause the cells to interpret 1-50 as Jan-50. If I then try to format the cell as text I get something like 18264. Any ideas on how to stop excel on interpreting those items as dates?- Hide quoted text -

- Show quoted text -