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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you make a "+" sign appear in front of positive numbers that you have
typed in?
 
Select yoiur range, click on Format Cells. Select Custom, and type the
following: +#,##0;-#,##0
 
You must log in or register to reply here.

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

Similar Threads

How do I display a "+" in front on positive numbers 3
Negative Numbers 8
Switching negative signs from back to front 4
Display plus sign 11
Display plus sign for positive numbers 2
pos & negative format?? 4
show plus sign in grid 3
how do I copy text with a plus sign at the front? 2

Back
Top