One more thing

  • Thread starter Exceling in Seattle
  • Start date
E

Exceling in Seattle

When I created a spreadsheet, in order to properly format the text in the cell (at least as I thought at the time) I entered numeric values as '10, '25, '47, etc. I would like to 'find' and delete all of these apostrophes so that the numbers would be true numeric values again. The only problem is that hte find function does not see the apostrophes, even when I search for them within the 'formula' instead of the 'values'. How can I quickly find these within a range of cells and zap them off.

Cheers!
 
D

Debra Dalgleish

To convert the text to numbers:

Select a blank cell
Choose Edit>Copy
Select the cells that contain the numbers
Choose Edit>Paste Special
Select Add
Click OK
To apply number formatting, choose Format>Cells
On the Number tab, select the appropriate format, then click OK.

There are other methods, described here:

http://www.contextures.com/xlDataEntry03.html
 
Top