please help with commas and point problem.

[fileman922]

hello, I have a field in my database, the field is set as currency. Now we are having a problem when insert the prices: 

1. we insert the price with the dot, as the image shows

2. when we click outside the field we get the number in thousands (not as we introduce it), as the image shows.

3. then we go to the field and change the dot for a comma, as the image shows.

4. then we click outside the field and we get the right value, ( filemaker replace the comma for a dot), as the image shows

 

please let me know how to fix this? right now we have to introduce the prices with commas to get the right value. 

thank you very much 

 

[Lee Smith]

Hi Fileman922,

Thanks for update your Profile.

This is just a wild ass guess, but Is it possible that you have a not English version of FileMaker?

or, did you get this file from someone that uses a none U.S. Version of FileMaker?

Lee

[siroos12]

Try to change the operating system settings for numbers. Most probably, your system is set to use "." as thousands separator and "," as decimal point. 

 

Here is a useful link for Windows :

https://www.isunshare.com/windows-10/customize-numbers-format-on-windows-10.html

 

And here is one for Mac:

 

https://m.wikihow.com/Change-the-Number-Format-on-a-Mac

 

Edited May 26, 2018 by siroos12