Hi Kris

Have you try this

Copy a empty cell
Select the cells with text values
Right click on the selection
Choose Paste Special ..... Add
OK
ESC



--
Regards Ron de Bruin
http://www.rondebruin.nl



"knutsenk" wrote in message ...
I tryed following the instructions for converting text to numbers and it
didn't work.
I am sure someone has had this problem. Any help appreciated.

thanks,

kris