Excel aligned negative number formatting

Ideas and tips for enhancing your TM1 application
Post Reply
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

Excel aligned negative number formatting

Post by iansdigby »

Apologies if this is already common knowledge.

I discovered today that the Excel technique of including "_)" in the postive area of a custom number format, in order to align positive values with negative numbers enclosed in brackets (or 'parentheses'), also works in TM1. I cannot see from the documentation how it is so, but the following gave me the desired result, and would surely bring joy to the hearts of accountants everywhere. They do have them (hearts).

BTW it includes dashes instead of zeros.

#,##0_);(#,##0);'-';' '

Regards, Ian
"the earth is but one country, and mankind its citizens" - Baha'u'llah
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

Re: Excel aligned negative number formatting

Post by iansdigby »

....and to make it even better,

#,##0_);(#,##0);-_);

which lines up the dashes too.
"the earth is but one country, and mankind its citizens" - Baha'u'llah
Post Reply