Negative number

[Chowder13037]

On my spead sheet I would like to make all my negative numbers red with a - sign in front of them but my format cells menu does,t give me the option is there a way around this ?

 

[Mark W.]

Roll your own...

0;[red]-0;0
This message was edited by Mark W. on 2002-11-07 17:30

 

[Mark O'Brien]

Select the cells you want to format, go to the "Format Cells" dialogue box and change the format to custom and add a new type:

#,##0_);[Red]-#,##0

 

[Mark W.]

On 2002-11-07 17:34, Mark O'Brien wrote:
Select the cells you want to format, go to the "Format Cells" dialogue box and change the format to custom and add a new type:

#,##0_);[Red]-#,##0

Mark, there's no need for _) if you're not gonna enclose the negative value in parenthesis.

 

[Chowder13037]

Thanks Guys I got it