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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do i put a addition sign before a digit in the cell box? (https://www.excelbanter.com/excel-discussion-misc-queries/30567-how-do-i-put-addition-sign-before-digit-cell-box.html)

Anns

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

Could u please help me out on this...

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).

"Anns" wrote:

Could u please help me out on this...

Bob Phillips

You could try a custom format of +General;General

--
HTH

Bob Phillips

"Anns" wrote in message
...
Could u please help me out on this...

All times are GMT +1. The time now is 02:37 AM.