Hi everyone,
I have a CSV file which I process with Excel.
One column contains 12-digit reference numbers.
If I append entries via Excel and save the file (in existing CSV file format), the next time I open the file in Excel the 12-digit numbers become ’rounded’, e.g. 123456123456 becomes 123460000000 etc
Any ideas on how I can maintain the 12-digits????
Even if I add a space to precede the number, the space gets ‘lost’ when Excel opens the csv file again.
zeddy