Thread: cell formats
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pammy Pammy is offline
external usenet poster
 
Posts: 96
Default cell formats

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?