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 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 Replies
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. 🙂
