Biff,
Try
=VALUE(SUBSTITUTE(A1,"°",0))*B1 where A1 is the text with Chr (176).
The text is converted to a number that can be used in another formula.
By substituting the 0 (Zero) for the ° degree character you lose any
background numerical accuracy.
Hint to enter the ° charater using the keyboard use "Alt 0176"


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=537324