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