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?

  • Have you checked the cell formatting? – Burgi Sep 15 '16 at 7:57
  • @Burgi - Thanks for your reply .Cells are in General Format and probably it will work if we change the format of the cell to TEXT but this gives the manual effort here which is not preferrable. – Vikram Sep 15 '16 at 8:45
  • Can you provide a quick sample of the data you are importing? – Burgi Sep 15 '16 at 17:01
  • Duplicate of superuser.com/questions/307496/… – thilina R Sep 26 '16 at 16:55

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.