So you have a bunch of numbers that are actually text??? If so then...

Place the number 1 in any blank cell.
Copy it
Select the range of text to be Converted
Select Paste Special - Multiply
Your text is now numbers...
--
HTH...

Jim Thomlinson


"kev" wrote:

please help