Thanks a million! I read the article and eventually I was able to solve the
problem with a "find and replace non-breaking space" command given in the
article.
Ruth

"Gord Dibben" wrote:

Ruth

You can try this method...........................

In Excel format all to General.

Copy an empty cell.

Select your range of "numbers" and Paste SpecialAddOKEsc.

If no joy, you could have extraneous spaces, specifically the 0160 space.

Try David McRitchie's TRIMALL macro.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall


Gord Dibben MS Excel MVP

On Sun, 27 May 2007 06:04:00 -0700, RuthZ
wrote:

Hello,
I have copied information from a charge card website and pasted the
information into an Excel worksheet. I have removed all formatting, but no
matter what I do, I cannot make the numbers read as currency. When I try to
use the SUM function, I get $0.00.
I know there must be formatting on the website, but I don't know how to get
rid of it so I can manipulate the data and figures in Excel.
If you can help, I would appreciate it.

Thanks,
Ruth Z