Negative Numbers

[Sue C]

I want my negative numbers to appear in parentheses, rather than with minus
signs. I thought I knew how to do this - go into Format Number and select
the parenthesis option from the negative numbers box. But when I try it, I
don't have a parenthesis option, just minus signs, or red. Any ideas?

Thanks.

 

[JE McGimpsey]

One way:

Format/Cells/Number/Custom 0.00_);(0.00);0_);@

 

[Mike]

Sue,

Use the custom format

#,##0.00;(##0.00)

As an extra you could use

#,##0.00;[Red](##0.00)

and get the numbers in red also.

Mike

 

[Joel]

Use custom format
enter: #.00;[Red](#.00)

 

[Sue C]

Thanks, this is great, just one step further though ... they are actually
currency values, so I need the format to include a £ sign (worked that one
out myself), but need the £ sign lined up to the left of the cell, with the
numbers to the right, so that it is consistent with positive values further
down the worksheet. Any suggestions?

Sue,

Use the custom format

#,##0.00;(##0.00)

As an extra you could use

#,##0.00;[Red](##0.00)

and get the numbers in red also.

Mike

I want my negative numbers to appear in parentheses, rather than with minus
signs. I thought I knew how to do this - go into Format Number and select
the parenthesis option from the negative numbers box. But when I try it, I
don't have a parenthesis option, just minus signs, or red. Any ideas?

Thanks.

 

[Sue C]

Forgot to say ... I also want a comma separator for my thousands. Want want
want!

Thanks, this is great, just one step further though ... they are actually
currency values, so I need the format to include a £ sign (worked that one
out myself), but need the £ sign lined up to the left of the cell, with the
numbers to the right, so that it is consistent with positive values further
down the worksheet. Any suggestions?

Sue,

Use the custom format

#,##0.00;(##0.00)

As an extra you could use

#,##0.00;[Red](##0.00)

and get the numbers in red also.

Mike

I want my negative numbers to appear in parentheses, rather than with minus
signs. I thought I knew how to do this - go into Format Number and select
the parenthesis option from the negative numbers box. But when I try it, I
don't have a parenthesis option, just minus signs, or red. Any ideas?

Thanks.

 

[JE McGimpsey]

Any suggestions?

Yes. Take a look at "About custom number formats" in Help.

There you will find you can use

£* #,##0.00_);£* (##0.00)

 

[Mike]

Sue,

Complete with left aligned £ sign and a comma.

£* #,##0;£* -(#,##0)

Will that do?

Mike

Forgot to say ... I also want a comma separator for my thousands. Want want
want!

Thanks, this is great, just one step further though ... they are actually
currency values, so I need the format to include a £ sign (worked that one
out myself), but need the £ sign lined up to the left of the cell, with the
numbers to the right, so that it is consistent with positive values further
down the worksheet. Any suggestions?

Sue,

Use the custom format

#,##0.00;(##0.00)

As an extra you could use

#,##0.00;[Red](##0.00)

and get the numbers in red also.

Mike

:

I want my negative numbers to appear in parentheses, rather than with minus
signs. I thought I knew how to do this - go into Format Number and select
the parenthesis option from the negative numbers box. But when I try it, I
don't have a parenthesis option, just minus signs, or red. Any ideas?

Thanks.

 

[Mike]

OMG I forgot the red

£* #,##0;[Red]£* -(#,##0)

Forgot to say ... I also want a comma separator for my thousands. Want want
want!

Thanks, this is great, just one step further though ... they are actually
currency values, so I need the format to include a £ sign (worked that one
out myself), but need the £ sign lined up to the left of the cell, with the
numbers to the right, so that it is consistent with positive values further
down the worksheet. Any suggestions?

Sue,

Use the custom format

#,##0.00;(##0.00)

As an extra you could use

#,##0.00;[Red](##0.00)

and get the numbers in red also.

Mike

:

I want my negative numbers to appear in parentheses, rather than with minus
signs. I thought I knew how to do this - go into Format Number and select
the parenthesis option from the negative numbers box. But when I try it, I
don't have a parenthesis option, just minus signs, or red. Any ideas?

Thanks.

 

[Sue C]

Perfectly! Thank you.

Sue

Sue,

Complete with left aligned £ sign and a comma.

£* #,##0;£* -(#,##0)

Will that do?

Mike

Forgot to say ... I also want a comma separator for my thousands. Want want
want!

Thanks, this is great, just one step further though ... they are actually
currency values, so I need the format to include a £ sign (worked that one
out myself), but need the £ sign lined up to the left of the cell, with the
numbers to the right, so that it is consistent with positive values further
down the worksheet. Any suggestions?



:

Sue,

Use the custom format

#,##0.00;(##0.00)

As an extra you could use

#,##0.00;[Red](##0.00)

and get the numbers in red also.

Mike

:

I want my negative numbers to appear in parentheses, rather than with minus
signs. I thought I knew how to do this - go into Format Number and select
the parenthesis option from the negative numbers box. But when I try it, I
don't have a parenthesis option, just minus signs, or red. Any ideas?

Thanks.

 

[Sue C]

That's just showing off! ;-0

OMG I forgot the red

£* #,##0;[Red]£* -(#,##0)

Forgot to say ... I also want a comma separator for my thousands. Want want
want!

Thanks, this is great, just one step further though ... they are actually
currency values, so I need the format to include a £ sign (worked that one
out myself), but need the £ sign lined up to the left of the cell, with the
numbers to the right, so that it is consistent with positive values further
down the worksheet. Any suggestions?



:

Sue,

Use the custom format

#,##0.00;(##0.00)

As an extra you could use

#,##0.00;[Red](##0.00)

and get the numbers in red also.

Mike

:

I want my negative numbers to appear in parentheses, rather than with minus
signs. I thought I knew how to do this - go into Format Number and select
the parenthesis option from the negative numbers box. But when I try it, I
don't have a parenthesis option, just minus signs, or red. Any ideas?

Thanks.