Excel aligned negative number formatting
Posted: Fri Mar 08, 2013 10:55 am
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
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