I want to get brackets round my figures not minus signs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...
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 Format>Cells>Number.....

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.

You will then be able to choose that format.

Gord Dibben Excel MVP
 
Back
Top