i want to put a bracket round my negative numbers not a minus sign how do i
do this? As when I attempt to it automatically converts it to a minus sign

Peru, format, cells, number, pick number or currency and pick the format you
want

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Peru" wrote in message
...
i want to put a bracket round my negative numbers not a minus sign how do
i
do this? As when I attempt to it automatically converts it to a minus sign

Peru wrote:
i want to put a bracket round my negative numbers not a minus sign how do i
do this? As when I attempt to it automatically converts it to a minus sign

Interestingly, if you set your Windows format for negative numbers to
have a bracket round them, Lotus *automatically* takes that as default.
Microsoft Excel, produced by the same company that makes Windows does
NOT!!!!!!! Come on MS, do some joined-up thinking for once!

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!

Peru

If bracketed negatives are not available in FormatCellsNumber.....

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

StartSettingsControl PanelRegional and Language SettingsRegional
OptionsCustomizeCurrencyNegative Currency Format. Click on drop-down arrow
and select the ($1.1)

Apply and OKApply your way out.

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

You will then be able to choose that format.

Gord Dibben Excel MVP

On Thu, 3 Feb 2005 03:45:05 -0800, "Peru"
wrote:

i want to put a bracket round my negative numbers not a minus sign how do i
do this? As when I attempt to it automatically converts it to a minus sign