I have a column of item numbers that have both text and numbers and are from
two different sources. I need to match the item# from both sources and found
that in a pivot table, many of the identitcal numbers are not recognized as
being the same item#. I tried formatting them as General or Number, or Text,
but this did not work. Any suggestions how to make all item#s recognized as
having the same format in order to be matched?

Thanks!
Amy