View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Hard values to convert to number

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?