Change display of positive numbers

  • Thread starter Thread starter cinders1850
  • Start date Start date
C

cinders1850

Hello,

Is it possible to change the display of positive numbers so that it displays
the plus sign (+) in MS Office Excel 2003? I tried the help screens but
couldn't find anything.

Many thanks.
 
Hello.
Try custom format :
+#0;-#;0
You'll have to change it if you want to display decimals, thousands
symbols, etc.
HTH
Daniel
 
That's done the trick! Many thanks.

Daniel.C said:
Hello.
Try custom format :
+#0;-#;0
You'll have to change it if you want to display decimals, thousands
symbols, etc.
HTH
Daniel
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display plus sign for positive numbers 2
Automatic display positive or negative 3
How can I always display numbers produced from subtractionas posit 2
How do I display a "+" in front on positive numbers 3
Numbers showing Up Centered in Cell ? 1
Convert neg. numbers to positive numbers 10
Display plus sign 11
Display "+" when appropriate 3

Back
Top