for general display purposes (to cover other formats too) perhaps
=TEXT(A1,"dd")&"°"&TEXT(A1,"mm.mmm")
might be better.

You would need to do this in a new inserted column B and Hide column A


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