simple columns won't add

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Phil" schrieb im Newsbeitrag
...
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

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)ValuesOKEsc.

Try your SUM again.

Gord Dibben Excel MVP

On Tue, 5 Oct 2004 07:20:23 -0700, "Phil"
wrote:

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

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

--
Don Guillett
SalesAid Software

"Phil" wrote in message
...
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