@random.next said:
As far as I know, Excel only displays it using scientific notation. But since it still has the full number, using appropriate formatting should show it as wanted.
The problem happens when you save the file in Excel. It's still a CSV file so it saves the representation of the number, not the full precision that would have been stored in a native Excel cell.
@KattMan said:
the problem is going the other way, take a CSV file and name it XLS and excell still opens it.
I think this only works for tab-seperated files. I tested it last year and I'm pretty sure I tried commas and tabs and only tabs worked. It does make a neat solution when your customer insists on getting Excel files and you don't want to install any extra components on the server.