Just a quick Thank you, I kind of figured it would take something like that but thanks for doing the work for me on this one.

As a followup you might know, if the character string is "$3999.99" the $ sign doesn't seem to be an issue when put in a date type field. Am I safe in that assumption?

Again.... thanks for your help....


>>Anyone know the best way to get:
>>
>>? VAL("3,000.99")
>
>The simplest trick I use is
>
>?val(chrtran("3,000.99", ", ", ""))