What do you get from
=ISNUMBER(J5) ?
=ISTEXT(J5) ?
Have you checked whether are spaces or non-printing characters in the cells
in question, either before or after your "numbers"?
--
David Biddulph

"kleivakat" wrote in message
...
No, no clipboard shows up. But I did change the entire J column to
currency
in the Format menu. I do think it has something to do with formatting....
I just can't figure out what!


"akphidelt" wrote:

Just a random question, when you highlight one of the cells does a
clipboard
pop up? Most of the time when I import data if a number is showing up as
text
you'll be able to change it by highlighting the data and clicking the
clipboard and changing the value to a number.

"kleivakat" wrote:

I'm trying to add up numbers in a column. It should be very simple,
but I
keep getting a zero result. The formula is =sum(J5:J113). I thought
that
the problem was maybe in the formatting of the numbers in column J
since they
were exported from another program, so I went into the Format menu and
made
sure they were formatted as currency. I'm still getting a zero result.
Any
other suggestions?