Microsoft Office Forums - View Single Post - [Solved] How to write the degree, minute second format in excel

Thread: [Solved] How to write the degree, minute second format in excel

View Single Post

Old

01-11-2011, 06:14 AM

Jamal NUMAN Jamal NUMAN is offline

Jamal NUMAN is offline

Jamal NUMAN uses Windows XP

Windows XP Jamal NUMAN uses Office 2007

Jamal NUMAN uses Office 2007

Office 2007

Expert

The original poster

Join Date: Nov 2010

Posts: 525

Jamal NUMAN is on a distinguished road

Default

How to write the degree, minute second format in excel

Hello everybody,

Please, see the attached image that shows my question

What I need is to write the degree, minute second format (which is used for example to measure the angles or geographic coordinates)

Normally, it’s written in the following format:

70 12’ 13’’

Thank you

Attached Images

Cliptt_4.jpg (97.5 KB, 123 views)