Hi Guru's,
I have an issue with the decimal separator and i'm not sure if NetSuite can solve this issue.
We are using the European Number format in NetSuite.
When you import a CSV the Decimal must always be a period (.) between the numbers and not the Comma (,)
When I make an export of a saved search the decimal seperator is always an , (comma). Even if I changed the field value in the saved search to text the export will always be in , in stead of the .
The options i've tried in the Saved Search are:
The Text option is the option I needed.
But when I export the to Excel the results are always with a , and not with a period (.)
In excel I can not replace the Comma for a Period because the values will change in some way
I tried to change the values of the cells to text and then change the , in to a . but nothing works.
When I export the Saved Search to CSV then the values are suddenly different from what is in the saved Search.
I even tried to change the Number Format to:
Then the results in the Saved search are correct but even then when I export this to Excel or CSV the Decimal is a , in stead of a .
Is there a way how I can solve this?
Or is it possible to do a CSV import amounts/numbers with a , instead of a . as Decimal sign?
That would also solves a lot of issues.
I would like to know if anyone can help me with this.
Thanks in advanced.
Regards Toanne