formatting a plus sign to automatically come in front of pos

[sb1000]

How do you format cells to automatically put a plus sign in front of a positive number so that, for example 24 will come out as +24

 

[Ivan F Moala]

On 2002-08-13 02:58, sb1000 wrote:
How do you format cells to automatically put a plus sign in front of a positive number so that, for example 24 will come out as +24

One way;
Custom format as "+"0;;;

 

[k209310]

Try this..

Highlight the cells that you need to format and select 'Cells' on the format menu or Press Ctrl+F1.

Select the 'Number' and and select custom in the category. Type the symbol you require in to the text box labeled as General making sure you ener some figures afterwards otherwise just the symbol will be displayed in your cell.

I hope this answers your question

K209310

 

[COLH99]

sb1000

I tried Ivan's code and found that a negative number did not show at all,
using his suggestion try "+"0;"-"0;0 this displays +24, -24, 0

 

[Mark W.]

Format as...

+0;-0;0

Note: There's no need for quote marks.

 

[Ivan F Moala]

On 2002-08-13 14:05, COLH99 wrote:
sb1000

I tried Ivan's code and found that a negative number did not show at all,
using his suggestion try "+"0;"-"0;0 this displays +24, -24, 0

Yes you are correct, I misinterpreted the Q and assumed the OP only wanted to show + numbers....thanks for checking.