How do you make a "+" sign appear in front of positive numbers that you have typed in?
F fairchildbrad Mar 1, 2007 #1 How do you make a "+" sign appear in front of positive numbers that you have typed in?
K kassie Mar 1, 2007 #2 Select yoiur range, click on Format Cells. Select Custom, and type the following: +#,##0;-#,##0
D David McRitchie Mar 1, 2007 #3 Format, cells, custom +#,##0.00_);-#,##0.00;"";@ http://www.mvps.org/dmcritchie/excel/formula.htm#cellformat
Format, cells, custom +#,##0.00_);-#,##0.00;"";@ http://www.mvps.org/dmcritchie/excel/formula.htm#cellformat
