Hi,
We have csv file automatically generated where rows look like:
"0123","04567","089".
The problem is that when Excel opens this file it puts it into cells like
123,456,89
stripping leading zeros. Is there way to generate csv file so that leading
zeros won't be stripped so it would like
0123,0456,089 when the file is opened in excel.

Thank you

Vadim

Hi Vadim,

rename the file a .txt file. Then you will have a choice for the type of
field, number or text

--
Kind regards,

Niek Otten

"Vadim" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
> We have csv file automatically generated where rows look like:
> "0123","04567","089".
> The problem is that when Excel opens this file it puts it into cells like
> 123,456,89
> stripping leading zeros. Is there way to generate csv file so that leading
> zeros won't be stripped so it would like
> 0123,0456,089 when the file is opened in excel.
>
> Thank you
>
> Vadim
>
>
>