Changing - to ()

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

Guest

I trying to change -3210 to (3120) but can't find how to do it. Can anyone
help me? I'm using the 2003 version. Thanks
 
Select the cell, then goto Menu Format>Cells>Custom, and add 0;(0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi,

Put -1 in a cell and copy it. Select the cell with -3210 in and then

Edit|Paste special
Select multiply and OK.
Delete the cell with -1 in

Mike
 
Click Format > Cells > Number tab
Choose Number under "Category", set the dp to zero,
select the desired bracket format from the list under "Negative numbers" > OK
 
Mike that didn't work. I got 1,716,536,781,789

I just want to put brackets round my minus number but all I get is the minus
sign. Any more ideas??
 
Sarah,

I may have confused you with my first and incorrect post.

With the number -1234 in a cell select that cell then:-
Format|Cell|Number
Select custom and paste in the formula
0_);(0)
Click OK and theminus sign will turn to (1234)

Mike
 
Max said:
Click Format > Cells > Number tab
Choose Number under "Category", set the dp to zero,
select the desired bracket format from the list under "Negative numbers" > OK
Click to expand...

Hi ,
Click Format > Cells >Custom and type #,##0;(#,# # 0) in Type..Press OK and
that's done.
 
sidm said:
Click Format > Cells >Custom and type #,##0;(#,# # 0) in Type..Press OK
and
that's done.
Click to expand...

Is the above preferable to the simple menu command in Format > Cells for the
OP's purpose here, I wonder ?

---
 
Max said:
Is the above preferable to the simple menu command in Format > Cells for the
OP's purpose here, I wonder ?
Click to expand...
I tried your method ,it does not work on my excel 2003 SP2.It would have been
simpler though.
 
sidm said:
I tried your method ,it does not work on my excel 2003 SP2.
It would have been simpler though.
Click to expand...

I'm using xl2003, too

Wonder which part of my response doesn't work for you?:
Click Format > Cells > Number tab
Choose Number under "Category", set the dp to zero,
select the desired bracket format
from the list under "Negative numbers" > OK
Click to expand...

Over here, under "Negative numbers",
for the bracket format,
I can click to select either:
(1234)
(1234) [in red]

---
 
If negative brackets are not available in the Number>Negative Numbers dialog.

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)

Note: this is under the "Currency" tab in Regional Options. Changing under
the "Numbers" tab only does not do the trick.

Apply and OK>Apply your way out.


Gord Dibben Excel MVP
 
Back
Top