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