View Single Post
  #1   Report Post  
jeremy via OfficeKB.com
 
Posts: n/a
Default changing all cells

I have a bunch of spread sheet with project numbers. On some of the
spreadsheets, the project number was written with a ' in front. How can I
change a whole column of numbers with an apostrophy (sp?) in front to just
the number without having to delete the apostophy in ever cell?

jeremy

--
Message posted via http://www.officekb.com