Maybe try putting a 1 in a blank cell. Copy that cell, the select your values
and click edit:Paste Special:Multiply?

HTH

"Guilherme Loretti" wrote:

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?