Hard values to convert to number

Giganews Newsgroups
Subject: Hard values to convert to number
Posted by:  Guilherme Loretti
Date: Tue, 9 May 2006

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?

Replies