raguay.customct Posted September 20, 2013 Share Posted September 20, 2013 Hi, I set the preference to force use of a comma for a separator, but it is showing a period. When I set to use the system preferences, it shows the comma okay. I have a screenshot of it: https://www.dropbox.com/s/p04w1pjsenrico1/AlfredSeparator.jpg Link to comment Share on other sites More sharing options...
Vero Posted September 25, 2013 Share Posted September 25, 2013 Hi, I set the preference to force use of a comma for a separator, but it is showing a period. When I set to use the system preferences, it shows the comma okay. I have a screenshot of it: https://www.dropbox.com/s/p04w1pjsenrico1/AlfredSeparator.jpg The Output preference you're referring to is for setting the decimal separator, not the thousand separator. If you're looking to use the period as thousand separator, choose the comma as decimal separator. Moving this to closed as it isn't a bug. Link to comment Share on other sites More sharing options...
raguay.customct Posted September 25, 2013 Author Share Posted September 25, 2013 The Output preference you're referring to is for setting the decimal separator, not the thousand separator. If you're looking to use the period as thousand separator, choose the comma as decimal separator. Moving this to closed as it isn't a bug. Your miss understanding me. If either of those options on that page is set to non-system default, I only get a decimal as the thousands separator. But, when my system is set to using a decimal for the thousand separator, I want to force the thousands to be a comma. But, no matter how these settings are set, I can not achieve that. Does that make better sense? Link to comment Share on other sites More sharing options...
Vero Posted September 27, 2013 Share Posted September 27, 2013 Your miss understanding me. If either of those options on that page is set to non-system default, I only get a decimal as the thousands separator. But, when my system is set to using a decimal for the thousand separator, I want to force the thousands to be a comma. But, no matter how these settings are set, I can not achieve that. Does that make better sense? Are you referring to the input (what you type) or the output (what is shown below your text box)? Here are a few output examples that should help you out. To force the output to 100,000.00, set the Output to "Use decimal point as separator" and check the box for "Show delimiter for thousands" To force the output to 100.000,00, set the Output to "Use comma as separator" and check the box for "Show delimiter for thousands" With these options, your results will show as you want them, regardless of your system defaults. Link to comment Share on other sites More sharing options...
raguay.customct Posted September 28, 2013 Author Share Posted September 28, 2013 That is what I would expect, but what I get is 1.234.33! Both of them being decimal. But, if I set to System Defaults for both input and output, then I get 1,234.33 for US, and my Thai system settings get the appropriate for Thailand. But, if I try to force it to be commas on the output, I get only decimals. Sorry, I am losy at describing thing. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now