You could also enter a 1 into another cell, highlight that cell and copy it
(ctrl+c or edit-copy), then select your cells containing the apostrophe and
select edit-paste special from the menu, select multiply as the operation,
and hit OK.


"DNA" wrote:

I've used this feature a lot, but can't seem to get this task
accomplished...

I have a column with numbers, but the first character is an apostrophe
('). I want to removed this character from this column so I can format
the column successfully.

Thoughts?? Thanks for your help!