>>>Hi
>>>
>>>I'm extracting some data from SQL and sending it out as a csv file.
>>>
>>>Some of the data is address data and some of the addresses (this seems peculiar to Scottish addresses for some reason ) have lines like 1/1. I assume these are flats in blocks.
>>>
>>>When the csv is opened this gets displayed as a date.
>>>
>>>Any thoughts on the best way to stop this happening.
>>
>>Open it in a text editor, not excel :).
>
>Thank you Dragan.
>
>I've passed on you email address as the contact/support point for all the eegits who complain about it.
http://drfairday.blogspot.com/search?q=excel