simple columns won't add

[Phil]

There's probably a very simple answer.

I'm checking out my Verizon wirless bill to understand
how I got charged. I copied all the detail records from
their web site and pasted them into a spreadsheet. I
only want to add minutes and charges. Simple right?

Below the columns I use a simple =SUM(J2:J300) but
continue to get only 0.00 for a total. (According to the
bill I should be getting $200 of values and they are
present in the spreadsheet in the J column.) All the
values are formatted as numbers. I copied an pasted to
new columns, I've done a "paste special" with values
only. Sum still = 0.00. I even assumed the values are
text and did a paste special multiply by 1. To no avail.

What am I missing?

Thanks in advance,
Phil

 

[Frank Kabel]

Hi
what does the formula
=ISNUMBER(J2)
return?

 

[Gord Dibben]

Phil

The numbers were brought in as Text.

Changing the format to Number does not alter the values.

Copy an empty formatted to General.

Select the "numbers" and Paste Special(in place)>Values>OK>Esc.

Try your SUM again.

Gord Dibben Excel MVP

 

[Don Guillett]

try
Sub ConvertThem() 'Harald Staff
Dim C As Range
For Each C In Intersect(Selection, _
ActiveSheet.UsedRange)
If Not C.HasFormula Then
If IsNumeric(C.Value) Then
C.Value = C.Value * 1
End If
End If
Next
End Sub