Cell has an apostrophe and is text

[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

 

[Ron de Bruin]

Hi Carole

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

 

[Guest]

It works!!! Thank you, Ron!!

Carole O

Hi Carole

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