Convert Number to Text Using Formula

[muhammad susanto]

hi all..

how to convert number to text e.g

-10% ---- to be text "negative"
50%----- to be text "positive"
0% ------ to be text "zero"

i hope don't use macro is possible

all number are given & random..

thanks in advance

.sst

 

[DanteAmor]

Somethig like this:

Book1
	A	B
1	5%	positive
Hoja2

Cell Formulas
Range	Formula
B1	=IF(A1<0,"Negative",IF(A1=0,"zero","positive"))

 

[DanteAmor]

If you want it to happen in the same cell, then put the following in the custom cell format.

"positive";"negative";"zero"

 

[muhammad susanto]

If you want it to happen in the same cell, then put the following in the custom cell format.

"positive";"negative";"zero"

thanks but i don't want use custom number format...it's possible

 

[muhammad susanto]

sorry Dante...working great!!!

thank you.

 

[DanteAmor]

thanks but i don't want use custom number format...it's possible

Then use the formula in post # 2. Or I don't know what you need?