Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 2392 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

537006805_ScreenShot2018-05-25at4_33_42PM.jpg.66b5ad41ff4e34b3be9093e99e6eeae7.jpg

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

1660578253_ScreenShot2018-05-25at4_33_20PM.jpg.89c2cc62fbb067d247a49e0f4b1f5763.jpg

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

718492_ScreenShot2018-05-25at4_33_54PM.jpg.f2cdb357e97e7ad7d074cfd0a82572ef.jpg

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

1667213975_ScreenShot2018-05-25at4_34_07PM.jpg.e0d4f70de81f5a7ad044544ce6d1ed22.jpg

 

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 

 

Posted

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

Posted (edited)

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 by siroos12

This topic is 2392 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.