I have cell shown part no. ST-09717 w/ qty 300pcs. I can't vlookup this cell
from other worksheet, however if I re-type the same part no. in the cell, I
would able to lookup this part no. and find 300pcs.

Is there a easy way to copy format instead of typing each part no. again in
the cell? Please help me ASAP.

Thank you,
Christy