If the text is in A1, then put this in B1:
=VALUE(A1)

"Jim C" wrote in message
...
I copied a website and pasted into excel. I need a formula to convert the
text to numbers.
Here are some examples, they contain leading 0"s, trailing 0's, "$" ","
and
"."
$9,405.98
$9,457.19

$14,420.92
$5,077.31

Thanks for any help
--
Jim C