Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
JE
Thanks! What about the opposite? (Column of numbers, add apostrophy in front of every number.) Jeremy -- Message posted via http://www.officekb.com |
#4
|
|||
|
|||
jeremy via OfficeKB.com wrote:
JE Thanks! What about the opposite? (Column of numbers, add apostrophy in front of every number.) Jeremy 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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
monitoring a changing range of cells | Excel Discussion (Misc queries) | |||
monitoring a changing range of cells | Excel Worksheet Functions | |||
Expanding conditional formating with reference cells changing | Excel Discussion (Misc queries) | |||
sort data without formulas in other cells changing? | Excel Discussion (Misc queries) | |||
CELLS HAVING SAME NUMBER BY CHANGING ANY CELL | Excel Discussion (Misc queries) |