wow, that actually taught me something too.

Glad you figured it out!

"kleivakat" wrote:

I just figured it out. The numbers imported with a dollar sign, which must
continue to be read as something other than a number. Since I have the
column formatted as currency and to show the dollar sign, I didn't see that
they were entered differently. I'll just eliminate the dollar signs and that
seems to take care of it. You learn something new every day.

"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?