View Single Post
  #1   Report Post  
Carole O
 
Posts: n/a
Default 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