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 lhp007 on May 12, 2020
by beermatt on April 22, 2020
by Prash Shirolkar on September 25, 2018