- This topic has 4 replies, 2 voices, and was last updated 5 years, 7 months ago by pka.
- July 21, 2017 at 18:57 #14975
The formatting of numbers through “Settings” in a given table has the following problem.
With the 2000 (format entered) and number setting = 1 yields: 2000. Changing setting = 1.00 yields: 2000.00. Further changing setting = 1,000.00 yields 2,000.00. Now: changing settings = 1,000 yields: 2000,000! and entering 2 in a cell yields: 2,000. How to solve this decimal-like behavior of the thousand separator?July 24, 2017 at 12:22 #14982
If I understood you right you want to use comma like a separator for thousands.
For this try to enter 1,000. at Number field of Data Format Settings – http://prntscr.com/fzibu2
In the cause I misunderstood you, please provide the detailed description of what you want to get in the result.July 25, 2017 at 00:13 #14987
Yes, I wish to use the “,” as a thousand separator in integers: 2 2000 etc >> 2 2,000 etc
If I enter 1,000 in the Number field of Data Format Settings and enter the number “2”. then the output is “2,000” and NOT “2” as expected.
If I enter 1,000 in the Number field of Data Format Settings and enter the number “2000”. then the output is “2000,000” and NOT “2,000” as expected.
If I enter 1,000.00 in the Number field of Data Format Settings and enter the number “2” then the output is “2.00” as expected.
If I enter 1,000.00 in the Number field of Data Format Settings and enter the number “2000”. then the output is “2,000.00” as expected.July 25, 2017 at 12:51 #14992
In order to get comma like thousands separator with out additional zeros, please make sure you entered 1,000. (one comma zero zero zero dot) inside Number field of Data Format Settings and saved changes – http://prntscr.com/fzibu2 . Then, go to front end to see the result. In the case you don’t see any changes try to clean cache in your cache plugin, clean cache in your browser and reload the page.July 25, 2017 at 13:08 #14993
That was a clever touch, thank you very much. It solved the problem.
Also, appreciate very much your expedient response.
- You must be logged in to reply to this topic.