G
@Qwerty said:@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.The real "beauty" of Excel is that it remembers your "text to columns" settings, and tries to apply them the next time you open any file, paste in data, etc. So if you ever split anything besides tabs, you'll see very odd behavior until you switch it back. (Well, not "odd" so much as just "Why the heck is it splitting this by spaces when I paste from the clipboard?") Hey Katt. Life treating you ok? :)