Display a number as + or -

[Dave]

Good morning everyone,

What is the easiest way to display a number along with a +
sign if it is positive?

Obviously the - sign displays automatically when a number
is negative.

Thanks for your help


Dave

 

[JE McGimpsey]

One way:

Format/Cells/Number/Custom +General;-General;General;@

 

[Guest]

That is fantastic - thank-you very much


Dave

-----Original Message-----
One way:

Format/Cells/Number/Custom +General;-General;General;@



.