I have a column in a report that is having varchar(18) data type. Example of the value is 100038475293847583. When viewing in html, it shows the value as specified. Howeverafter export to CSV, when viewing from excel on this csv the same value is now show as 10003847529347000. Somehow it is rounded. How can this rounding be avoided?
Excel only has up to 15 significant digits. I'd be willing to bet that if you examine the CSV in a text editor, the correct value is being exported. Excel is the problem here.