cVal = "22,000,000.00" nVal = val(chrtran(cVal, ",", ""))>Here's my problem - I'm not sure how to convert the text dollar amounts (i.e. 22,000,000.00) into a text dollar amount (i.e. 22000000.00) so that I can use the val function to convert it to a numeric value. Is there an relatively simple way to do this? The text file has about 10,000 records.
