In a helper column, try:

=SUBSTITUTE(A1,"'","")

Copy down as needed.
Then copy the helper column and using 'Paste Special' -Values, paste the
date back to the original column.

Regards,
Paul

"DNA" wrote in message
lkaboutsoftware.com...
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!