One more thing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding an apostrophe to a column of numbers 6
What is small green triangle in upper left corner of cell? 6
Remove Trailing Apostrophe 1
VB: inserting text into a cell (excel 03) 3
Cell has an apostrophe and is text 2
VLOOKUP reference issue 3
Can I replace a ' at the beginning of a text cell using Replace 4
Formatting to text - apostrophe does not show 3

Back
Top