Excel Macro Problem

[billbowers]

Hello. I have never been able to get macros to work. Maybe I'm using them wrong.

Is the following task possible with a macro?

In a cell there is: Stop($20.00)

What I need to do is remove the word Stop, the two parentheses, and the dollar sign; so that only the number, 20.00, remains.

I have many cells that I need to perform this task in; so I can reference the number in the cells to use in an algebraic formula.



I am not a novice Excel user. However, for some reason I have never gotten a grasp on what macros will and will not do.

Thank you very much.

Bill Bowers

[Pecoflyer]

You can find a possible solution here

[billbowers]

Originally Posted by Pecoflyer

You can find a possible solution here

Thank you SO VERY MUCH! You helped me more than you will ever know! This is going to save me many hours per month in my job!!!!!!!!!!! I tried it and it worked perfectly!

[Pecoflyer]

You're welcome