TableTools CSV formats decimal numbers as DATE in Excel
TableTools CSV formats decimal numbers as DATE in Excel
pbwned
Posts: 4Questions: 2Answers: 0
As the title says, I'm using decimal numbers (0.3, 1.2, 2.8,...) in a column. The problem is when I save it as CSV and open the file in Excel. Everything is fine except the decimal numbers which are like: 1.apr, 4.jun, 0.3 .. Which means it uses the date function. How to avoid this. Should I convert it to comma format?
This discussion has been closed.