Excel find and replace?

[tbuh]

Hey all,

I have a question about some data I'm sorting in Excel...

If I have a a list of numbers with negative numbers represented by "10.99-" can I somehow mess with the data and make it "-10.99"?

Thanks for your help.

 

[Magyar]

Assuming 1) they all have a minus sign on the right, 2) you want a negative numerical value ["10.99-" is text] and 3) the cell you want to change is in A1, try this:

=0-VALUE(SUBSTITUTE(A1,RIGHT(A1,1),""))

SUBSTITUTE drops the minus sign, VALUE converts the text to a numerical value, which subtracted from zero give you the negative value.

There are other ways to do this, too.