View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Guilherme Loretti
 
Posts: n/a
Default Hard values to convert to number

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?