Default Negative Number format across versions

[Jack Schitt]

Hi all

The regional settings on both of two machines at home are set the same:
negative numbers displayed in brackets (UK English region)
On one machine (XL97, Windows 98) I select Number Format and negatives are
prompted in brackets. If I transfer the workbook to the other machine
(XL97, Win95) the negative numbers in workbook are preceded by minus-sign.
If I select Number Format in this workbook the negative numbers prompted in
the dialog box are also preceded with minus sign.

I used to be content to live with this, but the problem is multiplying. Now
we have had Citrix installed at the office and all workbooks accessed
through Citrix display negatives as preceded by minus sign instead of in
brackets. It would be a huge effort change to custom number formats in all
workbooks.

Help??

Thanks

Jack

 

[Dave Peterson]

Try changing the Windows Regional settings|Currency Tab|Negative number format
to what you want.

 

[The Cube]

Doesn't work. Both currency and number formats had been set to negatives in
brackets in all machines.

Thanks anyway.

 

[Guest]

I am using Office Professional 2003. I cannot get Excel to display negative values in brackets instead of the minus sign. Can anyone help?

 

[JE McGimpsey]

One way:

Format/Cells/Number/Custom _(#,##0_);(#,##0);0_);@

 

[Gord Dibben]

Ed

This is a function of your Regional Settings in Windows OS.

Start>Settings>Control Panel>Regional and Language Settings>Regional
Options>Customize>Currency>Negative Currency Format. Click on drop-down arrow
and select the ($1.1)

Apply and OK>Apply your way out.

You will have to close Excel then re-open to see effects.

Gord Dibben Excel MVP