ExcelBanter - Cell has an apostrophe and is text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell has an apostrophe and is text (https://www.excelbanter.com/excel-discussion-misc-queries/15953-cell-has-apostrophe-text.html)

Carole O

Cell has an apostrophe and is text

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Carole O" wrote in message ...
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

Carole O

It works!!! Thank you, Ron!!

Carole O

"Ron de Bruin" wrote:

Hi Carole

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Carole O" wrote in message ...
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

All times are GMT +1. The time now is 10:55 PM.