User ( posted:

The following are the steps I think work for your problem.

1. Write a small function to strip off the dollar sign from the text box
2. Declare string variables like str1, str2, str_len,test_char. And str1 =
<value in the text box>
2. Convert the text box value into string using 'cstr'function ex. str1 =
3. Calculate the length of the string using 'len'function. ex str_len =
4. then for x = 1 to str_len
test_char = mid(str1, x, 1)
if test_char <> "$" then str2 = str2 & test_char
next x
5. Make sure to convert the str2 before you input.

I hope this will help.
Good luck
Satya Kandagatla