Microsoft Office Forums - View Single Post - [Solved] How to add the plus sign (+) automatically for the numbers which are positive?

Thread: [Solved] How to add the plus sign (+) automatically for the numbers which are positive?

View Single Post

Old

05-01-2011, 03:15 PM

Jamal NUMAN Jamal NUMAN is offline

Jamal NUMAN is offline

Jamal NUMAN uses Windows XP

Windows XP Jamal NUMAN uses Office 2007

Jamal NUMAN uses Office 2007

Office 2007

Expert

The original poster

Join Date: Nov 2010

Posts: 615

Jamal NUMAN is on a distinguished road

Thumbs up

Quote:

Originally Posted by macropod

View Post

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

Reply With Quote