Hi 525047,

Try this put 1 into a blank cell then copy it, then select all
your data and choose paste specialcheck multiply option
and OK. That will convert anything that is text to a number.

HTH
Martin