Opening a CSV in Excel

Question

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 · Answer

KeesW&nbsp;
Normally Excel recognizes negative numbers in CSV correctly. Could you attach some sample with few lines in question?

keesw · Answer

SergeiBaklan&nbsp;Here an example of the CSV file as attachment

keesw · Answer

KeesW&nbsp;Or try this file to import in Excel.

sergeibaklan · Answer

KeesW&nbsp;
&nbsp;
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.&nbsp;
&nbsp;
On which version of Excel you are?

keesw · Answer

I will send you an screenshot of my excel. See the attachments.SergeiBaklan&nbsp;

Forum Discussion

Opening a CSV in Excel

10 Replies

Resources