Thread: [Solved] How to add the plus sign (+) automatically for the numbers which are positive?
View Single Post
 
Old 05-01-2011, 03:01 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote