To extract the number from text is =value(A1) (in a separate column)
then copy and Paste Special, Values back over the A column (and delete
the helper column created)



bailey Wrote:
thanks, but I have tried this a few times and it doesn't work. I have
also assumed that the "wrong data type" is text and so I have followed
the instructions to change text to a number but that has not worked
either. Any other ideas? I really appreciate your help.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=490496