EK,

That apostrophe means that the cell contains text. Why do you care that it's
there? In general, you can just leave it. It' won't show up in the cell,
won't print.
--
Earl Kiosterud
www.smokeylake.com

"EK" wrote in message
...
How do I remove the hidden apostrophy in a cell (see e.g.)? I have tried
Find/Replace, changed the Alignment and formatted the cell but failed.

e.g.

'alphanumericdata