>>>>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"

Ok

thanks Boris