Fixing your data is, of course, the best thing to do; but you can work
around the problem if you will be pasting in data from this same source over
and over again. Assuming the problem is non-breaking spaces (ASCII 160
code), this formula should be able to sum your values (just adjust the range
for where your data actually is)...

=SUMPRODUCT(--SUBSTITUTE(A1:E1,CHAR(160),""))

Rick


"sylvia ong" <sylviaong@discussions.microsoft.com> wrote in message
news:95A82EA0-4E87-433C-A98F-AF3501A0FB9C@microsoft.com...
> Hi,
>
> I have tried it :( but it doesnt work.
>
> I found out the error, theres a space at the back of the number in the
> cell
> which prevents excel from recognising it as a number.
>
> Would u have any method to remove the space at the back?
>
> "AltaEgo" wrote:
>
>> Your data are formatted as text. Try this:
>>
>> Type a '1' in any cell.
>> Copy it.
>> Select all your pasted values.
>> Choose Edit, Paste Special and 'multiply'.
>>
>> --
>> Steve
>>
>> "sylvia ong" <sylvia ong@discussions.microsoft.com> wrote in message
>> news:FB5C66C0-270B-49C8-A597-9CA5D83FF902@microsoft.com...
>> > I copied numbers from a website to excel. I sum-ed the numbers up, but
>> > excel
>> > seem to be unable to recognise them as numbers.
>> > e.g:
>> > 8,735,279 13,037,465 4,932,955 7,304,148 7,538,364 --> sum =0
>> >
>> > However, if i retype all these values manually, excel can sum the
>> > numbers
>> > properly.
>> >
>> > Do help!
>> >
>>