Why does the thousands separator doesn't show?
-
- Posts: 5
- Joined: Wed Apr 19, 2023 4:51 am
Why does the thousands separator doesn't show?
I can't get the thousands separator to work at all. This is how it looks like in the settings:
The chosen format below shows it correctly: -1.234,56 but above it looks completely different.
Any Ideas what I do wrong?
The chosen format below shows it correctly: -1.234,56 but above it looks completely different.
Any Ideas what I do wrong?
Re: Why does the thousands separator doesn't show?
Why does the example have two decimal points in the number string? Could that be interfering with the comma placement?
My informal test suggests that this is the problem.
My informal test suggests that this is the problem.
-
- Posts: 5
- Joined: Wed Apr 19, 2023 4:51 am
Re: Why does the thousands separator doesn't show?
I was wondering about the same thing. But how to correct this I couldn't figure out.
Re: Why does the thousands separator doesn't show?
How to correct it?
Remove the wayward decimal point, of course.
Remove the wayward decimal point, of course.
-
- Posts: 5
- Joined: Wed Apr 19, 2023 4:51 am
Re: Why does the thousands separator doesn't show?
Removing the decimal points leads to this:
What? Isn't it supposed to show 1.000.000 instead? Separating the thousands? But it hangs a decimal point on the end and another 0...
The displayed Value is 1 Million typed 1000000 and with thousands separator on that gives me 1000000.0 What? Isn't it supposed to show 1.000.000 instead? Separating the thousands? But it hangs a decimal point on the end and another 0...
Re: Why does the thousands separator doesn't show?
I can't reproduce your result. It doesn't matter if I set the currency format to Europe (1) or Europe (2), with the number of decimal places set to zero I have no decimal places displayed.
-
- Posts: 5
- Joined: Wed Apr 19, 2023 4:51 am
Re: Why does the thousands separator doesn't show?
And with the "Thousands Separator" on you probably see 1.000.000 instead of 1000000.0 as it should be...
Just I don't. And no idea whether it is caused by a discrepancy between how windows wants to set the comma and how the program want's it?
Just I don't. And no idea whether it is caused by a discrepancy between how windows wants to set the comma and how the program want's it?
Re: Why does the thousands separator doesn't show?
Thanks for your post. Please check the settings region > Additional settings > Currency on your operating system level.
-
- Posts: 5
- Joined: Wed Apr 19, 2023 4:51 am
-
- SoftMaker Team
- Posts: 127
- Joined: Fri Sep 15, 2017 1:29 am
Re: Why does the thousands separator doesn't show?
Could you please provide us with a sample file? Normally, there are not allowed decimal separator and thousands separator the same - your screenshot shows that both are dots.