06-24-2019 08:52 AM
06-24-2019 04:23 PM - edited 06-24-2019 04:26 PM
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.
by realst8 on June 03, 2020
by cuong on May 27, 2020
by Ingeborg Hawighorst on May 13, 2020