Import is not working for currency field in suitecrm

I Tried to import the currency field in suitecrm in european format but it is not saving the correct value .

If I am importing 14,00 from file then it is saving 1400.00000 in database.

Please help in this issue. How this issue can be resolved


Welcome to the community!

You should use correct decimal separator for current user. Look at parameters for the user.

Problem is not with the separator . whenever i import 14,00 . it replaces the comma with zero and extra zero get added while import and value becomes 1400.00 .Please find the below screen shot for the reference

Please suggest if anywhere I am going wrong.