You can't, excel can only use 15 digits, are you really calculating with
these numbers?
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"Guilherme Loretti" wrote in
message ...
I have a table that has a column with "numbers" with 16 characters which I
cannot convert to number format using regular ways (if we use the formula
isnumber that will return FALSE). i tried to use MID, etc but still cannot
convert them in numbers. Is there somehow an easier way to do it?