>>>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.
>>>
>>>Thanks
>>>
>>>Nick
>>
>>Put some string before it.
>
>Would a space do it ?
Not sure, Maybe a single quote?
"'1/1"
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.