changing all cells

  • Thread starter Thread starter jeremy via OfficeKB.com
  • Start date Start date
J

jeremy via OfficeKB.com

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
 
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.
 
JE

Thanks!

What about the opposite? (Column of numbers, add apostrophy in front of
every number.)

Jeremy
 
jeremy said:
JE

Thanks!

What about the opposite? (Column of numbers, add apostrophy in front of
every number.)

Jeremy
Click to expand...
this handy little freebie has many functions like this built in so all
you need to do is select then from a menu. I've been using it for some
time without any problems. Standard disclaimer. I'm not affiliated with the
company in any way or do I profit from it's use.

http://www.asap-utilities.com/
 
Back
Top