Thanks again... It is amazing that there are so many prebuilt functions out there, but if you wanted to look in the help menu and serch for something you want to do, you can never find them. I knew there had to be an easier way then to go through each substr value of the character removing the $ and commas to do a val() of that. This was definately a quick an easy method.
>>I can use the MTON() function to convert a currency to a numeric, but I have a text format with a currency type in it, so I would need to convert that to a currency type first. I want my final result to be a numeric starting with a character field which contains a currency value in it. When I try a val() on say 2,456, it returns 2.00. Can someone tell me a quick way to convert these to numeric values?
>
>Try
? VAL(CHRTRAN(lcStr, [,], []))
``` Appreciate a normal day, it is always better than a bad one ```
Kev