As far as I know (") double quotes are used in the CSV file and who opening the file in Excel it should treat that as Text and all the numbers should displayed.
My actual CSV file value is: 1,026.549400 After converting to Excel it is : 1,026.55 I used double quotes in the program to get the commas in the value but I need to exact decimal values as this is critical data in the report. As the CSV file is transmitting to our client is there any chance to do this in CSV file without any manual work on Excel side.Can someone suggests me on this?
