ExcelBanter - Formating Cells

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

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

- - Formating Cells (https://www.excelbanter.com/excel-discussion-misc-queries/113732-formating-cells.html)

Untiedfullfillment

Formating Cells

Is there any way of formating one cell to display degrees, minutes, seconds,
insted of decimal degrees.

Can any one help!!

Untiedfullfillment

Niek Otten

Formating Cells

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Untiedfullfillment" wrote in message
...
| Is there any way of formating one cell to display degrees, minutes, seconds,
| insted of decimal degrees.
|
| Can any one help!!
|
| Untiedfullfillment

Untiedfullfillment

Formating Cells

Thank you for the link that was very helpfull

Untiedfullfillment

"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Untiedfullfillment" wrote in message
...
| Is there any way of formating one cell to display degrees, minutes, seconds,
| insted of decimal degrees.
|
| Can any one help!!
|
| Untiedfullfillment

All times are GMT +1. The time now is 10:16 PM.