dataport and thousands separator

balrog

Hello to all,

I`ve got a problem. I`ve created a simple dataport which exports a few columns from a table Item. One of these columns is quantity of items on stock. Sometimes quantity value gets over 999 pieces and here comes my problem. Dataport separates thousands with ˙ symbol and so for exaple MS Excel consider this field to be text. I have tried to look at my Local and language settings but found nothing. Can anyone give me an advice???? I need Attain not to use thousands separator.

Thanks in advance.

Balrog

Mehdi.Chahed

Hi man,

You just need to modify your Windows Regional parameters. :shock:
This is one of the stange things that haven't been olved even after Navision wedding with MS. :twisted:

Anyway,
by default, thousands separator is [space]. Go there and replace it by [.]. Unfortunately, you cannot let is as Blank.

This will solve Dataport and Copy/Paste problems.

Have a nice day!

balrog

Thanks a lot, Mehdi,

everything works fine now.

Have a nice day.