ExcelBanter - How do I format cell as longitude/latitude (ex: 45-30-10.65)?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I format cell as longitude/latitude (ex: 45-30-10.65)? (https://www.excelbanter.com/excel-discussion-misc-queries/134615-how-do-i-format-cell-longitude-latitude-ex-45-30-10-65-a.html)

ahmebah

How do I format cell as longitude/latitude (ex: 45-30-10.65)?

I am trying to set up a spreadsheet but having trouble with number format for
longitude/latitude. How can I get numbers to show up in example w/o making
it text?
--
ahmebah

JE McGimpsey

How do I format cell as longitude/latitude (ex: 45-30-10.65)?

See

http://cpearson.com/excel/latlong.htm

In article ,
ahmebah wrote:

I am trying to set up a spreadsheet but having trouble with number format for
longitude/latitude. How can I get numbers to show up in example w/o making
it text?

All times are GMT +1. The time now is 10:43 AM.