not able to completely save files correctly in a CSV format. Numbers come up as text and produces incorrect totals. We had several people on the team try and we are all having the same issue.
Answer
When you say
Numbers come up as text
I assume you mean that you double-click the newly created CSV file, and in excel the column containing the numbers is formatted as text?
Although it is odd that Excel does not guess the datatype correctly, you can avoid this issue entirely by importing the CSV file into Excel, instead of letting Excel auto-convert it. When Importing CSV into Excel, you can manually specify options like separator, data type, encoding, …. It is a much safer way of working with your data.
If you’re interested, I wrote an in depth article about this over here.
Attribution
Source : Link , Question Author : meredith helms , Answer Author : Wouter
