Combination text & numbers - use what format for pivot

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
in a dummy column put =value(A1) then whether 3.57 is number or text
it will be a value
 
Back
Top