Changing - to ()

[Sarah]

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

 

[Bob Phillips]

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)

 

[Mike H]

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

 

[Max]

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 H]

I suppose I should read posts before answering!!

Try a Custom format of

0_);(0)

Mike

 

[Sarah]

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??

 

[Mike H]

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

 

[sidm]

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

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

 

[Max]

Click Format > Cells >Custom and type #,##0;(#,# # 0) in Type..Press OK
and
that's done.

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

 

[sidm]

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

I tried your method ,it does not work on my excel 2003 SP2.It would have been
simpler though.

 

[Max]

I tried your method ,it does not work on my excel 2003 SP2.
It would have been simpler though.

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

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

 

[Gord Dibben]

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

 

[Max]

Ah, I see Gord's posting in the other branch.
It's something to do with regional settings

 

[sidm]

Ah, I see Gord's posting in the other branch.
It's something to do with regional settings

I think that might be the case as well..Thanks for the input.