It sounds as if your *numbers* are actually text. Try highlighting all you
*numbers* and then running this small Macro:

Sub ChangeIt()
For Each cell In Selection

If cell.Value < "" Then
cell.Value = _
--Application.Trim(Application.Substitute _
(cell.Value, Chr(160), ""))
End If
Next cell
End Sub

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"clivert" wrote in message
...
I copied a range of numbers into excel from the internet. When I try to
'Autosum' them they will not add. I also cannot format them e.g can't
change
them to a currency or change the number of decimal places of any number in
a
cell.