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?
Normally Excel recognizes negative numbers in CSV correctly. Could you attach some sample with few lines in question?
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