You often get the non-breaking space character (code 160) when
downloading data from a web-site. You can get rid of them in one
operation by selecting all the affected cells and then CTRL-H (or Edit|
Replace), then:

Find what: Alt-0160
Replace with: leave blank
click Replace All.

Alt-0160 means hold the Alt key down while typing 0160 on the numeric
keypad.

You might still need to multiply those cells by 1 to convert them from
text to numbers - ensure the cell format is set to General first.

Hope this helps.

Pete

On Jul 23, 4:40*am, sylvia ong <sylvia...@discussions.microsoft.com>
wrote:
> 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 o...@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!- Hide quoted text -
>
> - Show quoted text -