Change display of positive numbers

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.
 
D

Daniel.C

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

cinders1850

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
 

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

Top