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

Jamal NUMAN · #1 05-01-2011, 07:37 AM

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 · #2 05-01-2011, 03:01 PM

Hi Jamal,

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

Jamal NUMAN · #3 05-01-2011, 03:15 PM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word doesn't jumps tothe next lane when finds the dash sign!!!! why?	Jamal NUMAN	Word	3	04-10-2011 02:49 PM
replace automatically generated page numbers	LitWissOnline	Word	3	01-24-2011 03:40 PM
Numbers in Words	janak	Excel	2	12-19-2010 08:53 PM
How to sign out from the outlook?	Jamal NUMAN	Outlook	0	11-21-2010 07:28 PM
paragraph sign appearing in document	ajetrumpet	Word	1	08-24-2010 05:46 AM