You are facing one of the well-known Excel limits: Number precision of 15
digits.

For more information search Excel help for:
Excel specifications and limits

Check the "Calculations Specifications" section

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Guilherme Loretti" wrote:

1. How I get rid of ' in the beggining of a number (data comes from Access I
believe) - it gets confused with text formats
2. Once I try to convert this to number, I lose the last character,
renumbered to "0"
3. If I try to multiply by 1 or sum 0 to make it a number, also loses the
last character, renumbered to 0.
4. If I try to combine this "renumbered" to 0 number, using RIGHT/MID with
the last character removed, it turns back to text once its combined (using &)

Thanks