How do you make a plus sign appear in front of a number?
 

How do you make a "+" sign appear in front of positive numbers that you have
typed in?

How do you make a plus sign appear in front of a number?
 

Select yoiur range, click on Format Cells. Select Custom, and type the
following: +#,##0;-#,##0
--
Hth

Kassie Kasselman


"fairchildbrad" wrote:

How do you make a "+" sign appear in front of positive numbers that you have
typed in?

How do you make a plus sign appear in front of a number?
 

Format, cells, custom
+#,##0.00_);-#,##0.00;"";@

http://www.mvps.org/dmcritchie/excel...htm#cellformat
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"fairchildbrad" wrote in message
...
How do you make a "+" sign appear in front of positive numbers that you have
typed in?

How do you make a plus sign appear in front of a number?
 

Thanks guys. That helped solve my problem.