Hi!

Try this:

=LEFT(D5,FIND("/",D5)-1)/MID(SUBSTITUTE(D5,RIGHT(D5),""),FIND("/",D5)+1,255)0.5

Biff

"Mark C via OfficeKB.com" <u12467@uwe wrote in message
news:565eadaae4af7@uwe...
damorrison wrote:
I am not sure, is the value in the cell text??

The Text in the cell would be something like 1/16", 1/4", 5/8"


--
Message posted via http://www.officekb.com