Under - format - cells - number - negative numbers I do not have the option to choose 'brackets'
F Ferd Jan 31, 2006 #1 Under - format - cells - number - negative numbers I do not have the option to choose 'brackets'
R Roger Govier Jan 31, 2006 #2 Hi Maybe you need to go to Control Panel>Regional Settings>Customise>Negative number format. On my machine I get the option for brackets even when this is set to -1.1, but maybe for you, you need to set negative format to (1.1)
Hi Maybe you need to go to Control Panel>Regional Settings>Customise>Negative number format. On my machine I get the option for brackets even when this is set to -1.1, but maybe for you, you need to set negative format to (1.1)
G Gord Dibben Jan 31, 2006 #3 Hi also. When in Regional Settings, change the setting under "Currency" tab rather than the "Number" tab. Gord Dibben MS Excel MVP
Hi also. When in Regional Settings, change the setting under "Currency" tab rather than the "Number" tab. Gord Dibben MS Excel MVP
R Roger Govier Jan 31, 2006 #4 Hi Gord I think you had pointed this out to me once before. Sorry, the brain is getting"addled" today, and I totally forgot. Thanks for the memory jog.
Hi Gord I think you had pointed this out to me once before. Sorry, the brain is getting"addled" today, and I totally forgot. Thanks for the memory jog.
