Cell format to show + or -

[DargonSwift]

Is there a way I can create a custom cell format that place a "+" in front of the number if it is above 0 and a "-" if below 0?


-DS

 

[Andrew Poulsom]

Like this?

+0;-0

 

[Norie]

Perhaps a custom format like this?

"+"#;"-"#

 

[DargonSwift]

Like this?

+0;-0

EDIT: This one still lists zero with a "+" before it.


-DS

 

[Greg Truby]

Well, waddya want for zeros? Nuttin'? Then <ul>[*]+0;-0;0[/list]

 

[Scott Huish]

It can also be done with the General format, if desired:

+General;-General;0

 

[Greg Truby]

Pepper,

Other than General not masking off the decimals; would there be any other difference between Andrew's (or Norie's for that matter) and using General?

 

[DargonSwift]

Well, waddya want for zeros? Nuttin'? Then <ul>[*]+0;-0;0[/list]

Heh. Yes, zero should be "0". Thanks so much. I always learn so much on this forum.


-DS

 

[Scott Huish]

Greg,

Yes, if you didn't want to display a fixed number of decimal places, using General would allow you to do this.