|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to add the plus sign (+) automatically for the numbers which are positive?
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
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#2
|
||||
|
||||
Hi Jamal,
You can use a custom number format, via Format|Format Cells|Number|Custom: +#,##0.0;-#,##0.0;0.0
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Quote:
regards Jamal
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
|
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 |