Cell has an apostrophe and is text

G

Guest

I've downloaded a spreadsheet from the company intranet. One of the columns
I want as numeric has an apostrophe in front of the number. I cut, paste
save special, value and I can get rid of the apostrophe, but nothing I do can
change the cell to numeric. Any ideas

TIA,
Carole O
 
R

Ron de Bruin

Hi Carole

Copy a empty cell
Select your cells
Right click on them and choose Paste Special
Choose Add
OK
 
G

Guest

It works!!! Thank you, Ron!!

Carole O

Ron de Bruin said:
Hi Carole

Copy a empty cell
Select your cells
Right click on them and choose Paste Special
Choose Add
OK
Click to expand...
 

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

Leading Apostrophe 14
Adding an apostrophe to a column of numbers 6
What is small green triangle in upper left corner of cell? 6
Formatting to text - apostrophe does not show 3
Cell format 6
Leading Zero & Apostrophe - Help 2
How do I remove the apostrophe(') in front of zeros 3
Apostrophe In Data Downloaded 6

Top