On 30 July 2015 at 13:52, Simon Slavin <slavins at bigfraud.org> 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".
If you want the double quotes present in your MS Excel file, then you can use the "01234"; otherwise, you can prefix it with the single quote: '01234. -- ------- inum: 883510009027723 sip: jungleboogie at sip2sip.info xmpp: jungle-boogie at jit.si
