Say you have a column of numbers that are in text format. In an-unused cell
put 1.

Copy the cell and paste/special with multiply checked over the range of
cells you want to convert.
--
Gary's Student


"DMc2005" wrote:

Hi

i know there is a function to covert a number to text, si there a function
to convert text to a number.

D