On Wed, 15 Mar 2006 07:49:05 -0800, Claus Massmann
wrote:

After checking the contents of the cell I got rid of the 160 using the,
=TRIM(SUBSTITUTE(A1,CHAR(160),"")), formula.

Still the sum function adds the cells up to 0.00.

Comments?

You ignored part of my post (repeated below), so did not convert the text
result to a number:

You may need to precede this with a double unary if this is numeric data, as
the formula returns text.

=--TRIM(SUBSTITUTE(A5,CHAR(160),""))


--ron