this works for single digits like '45632 however I have some more complex
numbers such as '01.02354.321 or '01.54211 and this doesn't seem to work for
those numbers.
Please help.

"FSt1" wrote:

hi
1 way..
enter a 1(one) in a cell off to the side. copy it. then select the cell with
the apostropheed number. paste special multiply.
that should get rid of the apostrophe

regards
FSt1

"Candida" wrote:

Please advise how I can convert a number that comes over as '40593 from our
Italian firm. How do I take the ' off of the number. I have 3000 rows of
numbers that came through like that Please help.