Quote:
Originally Posted by Catalin.B
I guess you changed only the decimal separator to "," and the thousands separator is now the same with the decimal separator, which is not a bug, is a mistake. If you use "," as a decimal separator, and "." as thousands separator, in formatting the cell select 2 decimal places and check the option "Use 1000 separator (.)" , the entry 1441,75 will be displayed as 1.441,75.
If you keep "," as decimal AND thousands separator, AND you check the option "Use 1000 separator (,)" (notice that the option now has comma in the paranthesis), excel is confused, will consider that your entry is an integer with no decimals, because of using the comma as the 1000 AND (!!) decimals separator , thats why it shows ",00" to display the decimals......
|
No.
First, what you said is only relevant for number category, not currency category, if under number category(under format cells) you select "use 1000 Separator(,) you indeed get formatting like 1441,750,000.
Not only was this deselected by default so if I format the cell under number category I do get the correct format of 1441,75, but this option
does not exist under currency category.
Also under system separator of course I changed to comma for both decimal and thousands the first time.
Nothing you said is relevant, the problem still stands.
P.S.
I guess I could artificially "fix" this problem by formatting the autosum as number category and in the column next to it just type the currency, but that's not a real solution.