cell formats

P

Pammy

I have an excel worksheet sent from our Payroll dept from another application
used for Payroll. The column with emp #'s has a ' in front of the
number('21333). I have tried to edit - find ' but it doesn't find it. I
cannot do a vlookup because of this, I keep getting a ref# error. Any idea
on how to get rid of the ' in front of the number?
 
R

Rodrigo Ferreira

Try to use the function VALUE in other column to retrieve the emp #. After,
you can use VLOOKUP
 
G

Gord Dibben

Pammy

See the gnu's post which should get you straightened out.

But...........you should be getting #N/A returned, not #REF!


Gord Dibben MS Excel MVP
 
Top