help me defeat verizon

  • Thread starter Thread starter koki
  • Start date Start date
K

koki

hi:

i copied and pasted information from a table on the www
into an excel spread sheet...it came out to be 300+ plus
rows...the copy and paste looks exactly like table on the
webpage...

now when i try to add up all my numbers used in a certain
column and set the parameters, i keeps getting a result
of 0...i use the formula =sum(X:y) you get the idea. i
took all formatting off the cells using format>general
but nothing happens...


please help me as this cell phone provider is yet again
attempting to screw me.
 
Hi koki,

The values you copy/pasted may be *text* even though they
look like numbers. When this happens, even doing a format
as general does not change the value from being text. Try
this:

Select an MT cell somewhere on the sheet that is not part
of the pasted range. Copy that cell. Now select the range
that has been pasted. Do a Paste Special>Add. That should
convert the text values to numeric values.

To test the values in question, try this: in an mt cell
enter this simple formula: =ISTEXT(A1).

Biff
 
Back
Top