One way:

Copy an empty cell. Select your project numbers. Choose Edit/Paste
Special, selecting the Add and Values radio buttons.

Note that if your project numbers have leading zeros, this will
eliminate them unless the number format includes them.



In article ,
"jeremy via OfficeKB.com" wrote:

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