The ' is used to force the cell to a text format. If you remove it, the
displpay will likey drop the leading 0's unless it is formatted as a text
cell.

Having said that, you can remove it by using Find/Replace. Find ', and
leave the Replace box blank.

"Eliot" wrote:

When a list of numbers has been imported into Excel with an ' in front of the
first character (i.e. '0439333222), how can you convert that list so that the
' is removed?

Example: to convert '0439333222 to 0439333222

?

Any quick tips would be appreciated. Thanks.