Forum Discussion

KeesW's avatar
KeesW
Copper Contributor
Jun 24, 2019

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?
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 24, 2019

KeesW 

 

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?

  • KeesW's avatar
    KeesW
    Copper Contributor
    Jun 24, 2019

    I use Microsoft Excel (MS 365) for Mac version 16.26SergeiBaklan 

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jun 24, 2019

      KeesW 

      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.

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Jun 24, 2019

        SergeiBaklan 

        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.

         

  • KeesW's avatar
    KeesW
    Copper Contributor
    Jun 24, 2019

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

Resources