Cell formatting inconsistency

[moonfish]

Hey all,

I've been getting some weird missing indentations with the notation I'm using:

_(€* #,##0,k_);_(€* (#,##0,k);_(€* "-"??_);_(@_)

It's supposed to display numbers in thousands of euros, a minor adjustment to the default accounting format. However, it seems to randomly omit the space behind the k for the positive number, causing the numbers to be misaligned.

All of these values are numbers (eg 1237628.23762), none are the result of calculations.

It has to be part of the formatting condition because if I change the format to standard accounting all the numbers are properly aligned.

 

[Sektor]

_(€* #,##0,k_);_(€* (#,##0,k));_(€* "-"??_);_(@_)

 

[moonfish]

@Sektor
That seems to only add an extra bracket at the end of all the negative numbers.
I'm trying to consistently add an indentation the size of a bracket ')' at the end of the positive numbers.

 

[Sektor]

Instead of ")" write " " (empty space with parenthesis).

 

[moonfish]

Thank you for your time and your suggestions, I seem to have found a solution for the problem. Apparently there was some lingering secondary formatting in the cells somewhere.

I copied the values (values only) to a blank spreadsheet, applied the desired formatting and then copied the numbers back into the original sheet. Surprisingly, this worked.