How to strip currency symbol from textbox

[Bezzie]

How can I strip a currency symbol from a textbox that has been formatted as currency? I only want the value of the textbox without any other characters. When I Exit the textbox I want to write the value without the currency symbol to another textbox.

Val() doesn't work because it encounters the currency symbol before the actual value so returns 0.

My currency symbol is a 'R' but it could be any other currency as well.

[romperstomper]

You can't format a textbox as currency so either the currency symbol is being entered manually or it's being added in code. Neither one is a good idea. If you could have multiple currencies being entered on the same computer, you can't use CCur either.

[semajjames]

I use =LEFT(A1,FIND(" ",A1)-1) to take only numbers from a cell containing numbers and letters where A1 = 240 MH/s

if that helps

[Bezzie]

Romperstomper: Yes. It's formatted through code. It's simply done to display a view textbox where the value is displayed as currency (to make it look good).

But when the user needs to change the value it gets changed in the view textbox that is then transferred to the hidden textbox where it's not currency. This works when the amount is changed as the text, including the currency symbol, in the view textbox is selected and the amount entered replaces the currency symbol and the amount. On the exit of the view textbox the value is then transferred to the hidden textbox and the amount in the view textbox is again formatted to display as currency.

When it doesn't work is when the user tabs through the view textbox without changing the value. In this case the currency symbol is still in the view textbox and is then transferred, on exit, to the hidden textbox along with the value

Semajjames: Your example has pointed me in a good direction. Working on a function to extract only numbers from the textbox text.

[romperstomper]

If you added the symbol in the code, you should know what it is, and it would be a simple replace call or, if it's the user's local currency, you can simply use CCur. For example, since my regional currency is £, CCur("£1.25") will return 1.25

[Bezzie]

Problem is when you're working with exchange rates. Then you're working with all currency symbols except Zim$ of course. Not enough space on a screen for a textbox long enough to display that currency

[romperstomper]

So your code didn't add the symbol then?

At any rate, I would suggest a separate box for the currency identifier - it will make life simpler.