How do i put a addition sign before a digit in the cell box?

J

JMB

you will need to put a single quote in front of the number, treating it as
text.

Cell A1 = '+6

Excel will convert it back to a number if you use it in a calculation such as

=A1 + 5 wil return 11.

Also you can convert it to a number for any formulas by using =Value(a1).
 
Top