Cell formatting: displaying lat/long coordinates

Giganews Newsgroups
Subject: Cell formatting: displaying lat/long coordinates
Posted by:  Nelson (runriverr…@msn.com)
Date: Mon, 10 May 2004

Rather than formatting a cell to display time in hours and minutes and =
seconds, I would like to display latitude and longitude in degrees, =
minutes, and seconds.
e.g. 43=BA 25' 34"

Is this possible in Excel 2000?

Replies