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?
SergeiBaklan Here an example of the CSV file as attachment
I'm able to open it without any problems, as well as import both by legacy and Power Query connectors. Result saved as xlsx is attached.
On which version of Excel you are?
I use Microsoft Excel (MS 365) for Mac version 16.26SergeiBaklan
Perhaps that's an issue like here. I tried to play with different options, but I'm on Windows and on English version - was not able to reproduce an error.
I will send you an screenshot of my excel. See the attachments.SergeiBaklan
