Gord,

Your instructions work!!! You are the best!!! Thank you very much for your
assistance. I really appreciate your time for working on this problem.
Your time and information are greatly appreciated. You have saved me a
tremendous amount of time to manually rekeying those numbers.

Again, thank you very much.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Diane sent me the workbook.

All "numbers" had the dreaded non-breaking 160 character at right side.

Found by using Chip Pearson's CellView add-in, which I would not be
without.

http://www.cpearson.com/excel/CellView.htm

Did an EditReplace and all's well.

David McRitchie's TRIMALL macro would have also stripped the 160 char.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall


Gord

On Thu, 01 Feb 2007 15:50:56 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Diane

If you wish, you can send the workbook to my email.

I am curious now.

Change the AT and DOT to appropriate punctuation.


Gord

On Thu, 1 Feb 2007 15:15:49 -0800, "Diane Walker"
wrote:

Gord,

Thank you very much for your prompt response and information. I
formatted
all cells to General or Numeric and followed the instruction. The Total
cells still got the error message "#VALUE!".

If I formatted the columns as Numeric and manually retyped the numbers, I
do
not get an error message in Total cells. However, there are about 400
numbers in each column, I might make a mistake when I retype those
numbers.
But, I might have to do it if I don't have any choice. Thanks very much
for
your help.