Custom format in Excel 2011 doesn't decimal-justify.

I like to use brackets and red fonts for negative numbers. When I use either of these custom formats, the decimals don't align.

#,##0.00;(-#,##0.00)

#,##0.00;[Red](-#,##0.00)

Thanks for helping me resolve this.

Try it with spaces either side of the format string for positive numbers. I can't really show it here, but it will be two or three spaces before the first # (to counteract the (- of a negative number) and a space before the ; to counteract the close bracket. You might need to play about with the number of spaces to get it looking right.

Hope this helps.

Pete

The best alignment seems to be two spaces before the semi-colon on the positive side and one space before the minus sign on the negative side.

Thanks for your tip!

Well, glad to help. The number of spaces will depend on the font you are using and the font size, so you do have to experiment a bit each time.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete