Biff,
Go to FormatCellsNumberCategory Custom and Type:
0.00 ° Insert the ° using the keyboard entry from my first post. It
works for me.
The entry into the cell either by typing or by formula puts a ° symbol
after the number and yet the cell contents can still be used in other
formulas because it reads like any other number.

Hope that is what you were looking for.


--
Casey


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