How to add the plus sign (+) automatically for the numbers which are positive?

[Jamal NUMAN]

How to add the plus sign (+) automatically for the numbers which are positive?

please, see the attache image that shows my question.

i performed a subtraction process, and i got negative and positive numbers. how could i add the plus sign (+) for the positive numbers in this case?

regards

Jamal

[macropod]

Hi Jamal,

You can use a custom number format, via Format|Format Cells|Number|Custom:
+#,##0.0;-#,##0.0;0.0

[Jamal NUMAN]

Originally Posted by macropod

Hi Jamal,

You can use a custom number format, via Format|Format Cells|Number|Custom:
+#,##0.0;-#,##0.0;0.0

Thank you Paul. It did work.

regards

Jamal