Cell has an apostrophe and is text

C

Carole O

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
 
C

Carole O

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...
 
Top