Hi Laura,
If you intend to enter more "numbers" as text be sure to format
that column as text first. What you have from SUBSTITUTE will remain
as text unless you reenter it such as hitting F2 then ENTER.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Laura K" wrote in message ...
Thank you. That gives me exactly the result I need.

"Duke Carey" wrote:

Once you have the formulas all set up correctly, copy the entire range/column
of formulas, select the original values, and use Edit-Paste Special-Values
to replace the original values. Then delete the column with the formulas in
it.