Extracting numbers and decimals from cell

[rangequestion]

Hi,

I have a column of data that is formatted like this: "+$ 29,635.94" for positive numbers and "-$ 50,000.34" for negative numbers. How can I just get the numbers without the negative or positive sign and the dollar sign with the space after it?

Thanks!

 

[steve the fish]

Try this:

=0+MID(A1,4,99)

 

[rangequestion]

Try this:

=0+MID(A1,4,99)

Well that was fast, thanks a ton!

 

[Scott Huish]

=abs(a1)
Format as a dollar format.