Kris

If Ron's method does not do the job, perhaps you have some junk in the cells.

Extra spaces, non-breaking spaces to name a couple.

Depends upon where the text is imported from.

Post back if that is the case.


Gord Dibben Excel MVP

On Sat, 2 Apr 2005 09:33:58 +0200, "Ron de Bruin"
wrote:

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