Use a custom number format of
#00°00'00\"

To get the degree symbol, hold down the ALT key and type 0176 on
the numeric keypad.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"surveyor" wrote in message
...
I have coordinates in excel as ddmmss, how do I format it so
that it is ddº
mm' ss"