Not able to sum

[ice_breaker]

Hi all,

I copied the info from the web and pasted to Excel. Then, I tried to sum up the numbers, but it showed 0. Can anyone advise me why I couldn't sum it up. Thanks

P.S. please find the attached file for reference

[Alfredim]

You have it as text , insert the numbers manually or paste special as numbers.
It will work

[alansidman]

See if this link helps

https://support.office.com/en-us/art...c-fe5303222c9d

[ice_breaker]

I tried to input it manually and it worked. But other option, paste special as values, didn't work. Does it work at your end? if so, please show me how to do that. Thanks

[Alfredim]

You are not able to do nothing because you have "." in the middle of the number and a space at the end. You have to delete them. Use the find and replace (ctrl+f) to dele them, then use the formula =value(a1) to get them as number.

[ice_breaker]

Thanks. It does help.

[Alfredim]

Can you add reputation to me? just click on the star bellow your name.

Thank you