See if this works for you:

Put a 1 in an empty cell
Copy that cell (EditCopy)
Select the range of text numbers
EditPaste Special
Select:Multiply and Values
Click [OK]

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=375746