Anybody knows a way to default Excel to display negative number in red bracket e.g.
for -12 -> (12) permanently?
Know the way to set this manually by Format Cells function/Format Painter/Modify Normal Style but all these have to be done as per spreadsheet basis. Want to find a way to setup Excel to default using this Negative Number format for every spreadsheet and so the spreadsheet will open up to display the negative number in this format without the need to do the format again.
Have customized Regional Options to use (1.1) as the negative no. format.
OS : Windows XP
Excel : 2003
for -12 -> (12) permanently?
Know the way to set this manually by Format Cells function/Format Painter/Modify Normal Style but all these have to be done as per spreadsheet basis. Want to find a way to setup Excel to default using this Negative Number format for every spreadsheet and so the spreadsheet will open up to display the negative number in this format without the need to do the format again.
Have customized Regional Options to use (1.1) as the negative no. format.
OS : Windows XP
Excel : 2003