Forum Discussion
Opening a CSV in Excel
I opened a CSV-file in Excel 365. The problem is that negative numbers do not convert in the cells. The result is #VELD! instead of the negative number. Whats the problem and how to solve it?
It looks like a bug.
It's the #FIELD! error type.
It is triggered on systems where the . (dot) is not the decimal separator and Excel interprets it as a formula because of the - (minus sign). And because the formula contains a . (dot) Excel thinks this a reference to a linked data type. Of course there is no such linked data type or data type field and Excel throws an error.
This happens when you use text to columns with unchanged options.
If you change the format of the columns to text in the third step there will be no error.
And no problems with Power Query but that is not yet available to Macs.
Indeed, it looks like a bug. Thank you for the solution, it works by changing the format to Text in the 3rd step.Detlef_Lewin