Text to columns returns 'Field' error for negative (-) values

[WillemII]

Converting Text to columns of:

04-10-2018,NL02SNSB0858516373,,,,,,EUR,1122.46,EUR,-169.40,04-10-2018,04-10-2018,7903,BEA,30977536,'3eef24/537689','Het Rubberhuis        >MAASTRICH 4.10.2018 12U13 KV002 679F2G   MCC:5169',20

Delivers:

4-10-2018

NL02SNSB0858516373

EUR

1122.46

EUR

#FIELD!

4-10-2018

4-10-2018

7903

BEA

30977536

'3eef24/537689'

'Het Rubberhuis        >MAASTRICH 4.10.2018 12U13 KV002 679F2G   MCC:5169'

20

'Het Rubberhuis        >MAASTRICH 4.10.2018 12U13 KV002 679F2G   MCC:5169'

20

[#2]

Do you use General format for that field on third step of the wizard?

[#3]

To clarify a bit (as i myself came here looking for answers to the issue); when using the 'Text to columns' tool you have 3 steps.
On the 3rd step, which i personally usually skip, you can choose the output format of each column.
If you pick 'text' (instead of 'general') format for the column with the #field error, the error doesn't occur.
I hope this helps. :)