Forum Discussion
Text to columns returns 'Field' error for negative (-) values
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 12...
Do you use General format for that field on third step of the wizard?
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. 🙂
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. 🙂