How to eliminate the Sign?

[ianccy]

I have a column of cells with values such as 500,000,000+ ,250,000- and so on, some cell don't have the '+' or '-' sign, how to write the formula to eliminate the '+' or '-' sign?

The sign always comes after the no.

 

[Aladin Akyurek]

Use the formula...

=IF(ISNUMBER(A1),A1,(RIGHT(A1)&LEFT(A1,LEN(A1)-1))+0)

or the ASAP Utilities from

http://asap-utilities.com

Aladin

 

[gnaga]

Book1
	A	B	C	D
1	5200+	5200
2	52104-	52104
3	50000120+	50000120
4	145268-	145268
5	125638+	125638
Sheet1

Hope this is what you want.

GNaga

 

[ianccy]

Thank you