How do I display a "+" in front on positive numbers

[Bob]

I like that Excel puts a negative sign "-" in front of negative numbers but
how do I get the positive sign in front?

 

[Jarek Kujawa]

Format->Cells->Custom
+# ##0;-# ##0

 

[The.Q]

To get a positive sign (+) in front of positive numbers, create a custom
number format as follows:

+#,##0;[Red]-#,##0

 

[Jacob Skaria]

Format-->CustomFormat-->

+ ##;- ##

If this post helps click Yes