On Thu, Jul 30, 2015 at 10:52 PM, Simon Slavin <slavins at bigfraud.org> wrote:

>
> On 30 Jul 2015, at 9:50pm, Sylvain Pointeau <sylvain.pointeau at gmail.com>
> wrote:
>
> > leading
> > 0 are removed when opening a csv file by double clicking on it to open it
> > in excel.
>
> This is documented behaviour in Excel, which assumes that all cells
> contain numbers, and therefore that leading zeros can be removed.  If you
> don't want them removed you have to quote the value, e.g. "0123".
>
> Simon.


no it does not work double clicking on the csv to open it in excel, I am
100% sure (I just tried again), you have to go through the data->import and
set up the columns as text for it to work

Reply via email to