I copied some information from 2 sets of bank statements--"Bank Checks" and
"Direct Deposits" (in Explorer web page form)--into a series of Excel sheets,
intending to use the 'sum' function to total the amounts for particular
accounts. To my chagrin, Excel only recognizes *some* of the data--the
minority, that came from the pages for "Bank Checks." Any data I've pasted
from the "Direct Deposit" screens isn't recognized by the function feature
(the data is definitely in the cells, but when I try to add them the function
performs and comes up with "$0"). Using the function feature on the "Bank
Checks" data (which is in the same screen, same column, as the "Direct
Deposit" data) works just fine. Does anyone have any idea what's wrong?

Your values are being copied as text, which is common when copying from
a web site, especially if the site uses non-breaking spaces, CHR(160),
rather than CHR(32).

To coerce the text numbers to XL numbers: Copy a blank cell. Select your
values. Choose Edit/Paste Special, selecting the Values and Add radio
buttons.




In article ,
ConfusedDataMonkey
wrote:

I copied some information from 2 sets of bank statements--"Bank Checks" and
"Direct Deposits" (in Explorer web page form)--into a series of Excel sheets,
intending to use the 'sum' function to total the amounts for particular
accounts. To my chagrin, Excel only recognizes *some* of the data--the
minority, that came from the pages for "Bank Checks." Any data I've pasted
from the "Direct Deposit" screens isn't recognized by the function feature
(the data is definitely in the cells, but when I try to add them the function
performs and comes up with "$0"). Using the function feature on the "Bank
Checks" data (which is in the same screen, same column, as the "Direct
Deposit" data) works just fine. Does anyone have any idea what's wrong?