add symbols to DMS

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

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" <surveyor@discussions.microsoft.com> wrote in message
news:F6D710D5-A5E4-4289-8B25-2E74A3BC7B6B@microsoft.com...
>I have coordinates in excel as ddmmss, how do I format it so
>that it is ddº
> mm' ss"
>