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
Click to expand...
 
Top