If you feel comfortable with VBA, you can try:

Sub numerify()
Dim r As Range
Count = 0
For Each r In ActiveSheet.UsedRange
If Application.IsText(r.Value) Then
If IsNumeric(r.Value) Then
r.Value = 1# * r.Value
r.NumberFormat = "General"
Count = Count + 1
End If
End If
Next
MsgBox (Count & " cells changed")
End Sub


--
Gary's Student


"Craig Fletcher" wrote:

Ah-ha... the cells I pasted in here do have spaces after the "numbers" (that
won't act like numbers). I tried the TRIM function in Excel but the spaces
won't go away. I'm not very familiar with VB or Macros, but I saw the site
and I am going to try some more.

Thanks for the tip....

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Craig

The numbers are probably copied in as text.

Re-formatting alone will not change them.

Try this method...................

Format all cells to General.

Copy an empty cell and selet the "numbers"

Paste SpecialAddOKEsc

That should change the "numbers" into real numerics.

If no joy, there could be spaces before or after the numbers.

These could be non-breaking spaces(160) which can be hard to get rid of.

David McRitchie has a TRIMALL macro that looks for the non-breaking space
(160)
along with other crap in cells.

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


Gord Dibben MS Excel MVP

On Mon, 1 May 2006 12:59:00 -0600, "Craig Fletcher"

wrote:

I have some data that I copied out from a webpage (a credit card summary)
which I have since added several other columns around it (i.e., I would
much
rather not have to paste it again) and the numbers won't act like numbers.
I've tried copying them out, and doing "paste special" into a new
worksheet
with all of the different "paste special" options, and I have also tried
all
of the formatting options (currency, numbers, etc.) and still they will
not
be treated as numbers by Excel.

Is there anything else I can try?

Thanks,
Craig


Gord Dibben MS Excel MVP