SUM Not Working

I

inveni0

I have a column of numbers (currency). I have formatted it to Currenc
type. However, when I run a =SUM(H:H) formula (in a separate column
of course) it returns only the value of the last field. If I ru
=SUM(H1:H7) as a test, it returns "0".

Any ideas
 
I

inveni0

It appears to be a format problem! Is there a way to strip the $ sig
out of a cell and place the result in another cell
 
I

inveni0

Solved it. The data I was importing had extra spaces...I had to do
find/replace...fixed 'er right up
 
Top