View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default I seem unable to display negative values with brackets

Hi also.

When in Regional Settings, change the setting under "Currency" tab rather than
the "Number" tab.


Gord Dibben MS Excel MVP

On Tue, 31 Jan 2006 07:35:54 -0000, "Roger Govier"
wrote:

Hi

Maybe you need to go to Control PanelRegional
SettingsCustomiseNegative 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)