Perhaps this can be of help:
http://groups.google.com/group/micro...8b29cb1aecacf4
--
Gary''s Student
"DMc2005" wrote:
Sorry no good
numbers are picked up from a string of text.
D
"Gary''s Student" wrote in message
...
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