Thanks for the assistance Ron, however that did not work either. I am
attaching a couple of numbers from the sheet I am trying to convert.

3
5
16
11
24

I tried copying these back from here to the Excel sheet, matching
destination, and then the multiply solution worked. So I will copy out of the
worksheet into another application and back again. However, I often need to
do this so if you have an easier method I am all ears. Thanks in advance for
your help.

Kris Knutsen

"Gord Dibben" wrote:

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