They were imported as text rather than numbers:

1. in an un-used cell enter 1
2. copy this cell
3. Paste/special/multiply onto the cells you want to convert from Text to
Number
--
Gary''s Student - gsnu200768


"jasonr17" wrote:

I have a simple setup of data that originated from a .csv file. I copied,
pasted values into a specific set of cells, yet the sum formula isn't picking
up on the numbers.

The formula DOES pick up on the number when I double click each each
individual cell with data in it.

I've pulled all formats, trimmed, and am looking at the numbers, yet they
are not totalling at the end of the row unless I go through each one and
double click?

Any ideas?