Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
convert decimal to sexagesimal
767 views
Skip to first unread message
theorrix
May 19, 2010, 2:28:01 AM5/19/10
to
How can i type into an excell cell with decimal degrees and get common
degrees minutes and seconds
degrees minutes and seconds
Phil Hibbs
May 19, 2010, 5:51:56 AM5/19/10
to
On 19 May, 07:28, theorrix <theor...@discussions.microsoft.com> wrote:
> How can i type into an excell cell with decimal degrees and get common
> degrees minutes and seconds
> How can i type into an excell cell with decimal degrees and get common
> degrees minutes and seconds
http://support.microsoft.com/kb/213449
Phil Hibbs.
helene and gabor
May 19, 2010, 6:17:05 AM5/19/10
to
Hello,
Type a number say in A1, the first digit is: (say in C1) =INT(A1/60)
the second digit (could be multiple) is: A1-C1*60
best regards,
Gabor Sebo
------------------------------------------------------------------------------------------------------------------------------------------------------------------
"theorrix" <theo...@discussions.microsoft.com> wrote in message
news:2C7C5BC7-B942-4529...@microsoft.com...
0 new messages