Hi
It sounds as though the values may have come across as Text.
In a spare cell on your sheet, enter the number 1. Copy the cell, mark
the range of Data you have copied and Paste Special>Multiply.
That may well coerce the values to numeric.
Alternatively there may be extraneous spaces, or the non-breaking space
character Char(160) embedded within the data.
Use David McRitchie's TRIMALL() function to clean up the data.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
