Prev: loop through all worksheets
Next: Application.OnTime - Macro Cannot Be Found - Internet Explorer
From: theorrix on 19 May 2010 02:28
How can i type into an excell cell with decimal degrees and get common
degrees minutes and seconds
From: Phil Hibbs on 19 May 2010 05:51
On 19 May, 07:28, theorrix <theor...(a)discussions.microsoft.com> wrote:
> 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.
From: helene and gabor on 19 May 2010 06:17
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
------------------------------------------------------------------------------------------------------------------------------------------------------------------
----- Original Message -----
From: "theorrix" <theorrix(a)discussions.microsoft.com>
Newsgroups: microsoft.public.excel.programming
Sent: Wednesday, May 19, 2010 2:28 AM
Subject: convert decimal to sexagesimal


> How can i type into an excell cell with decimal degrees and get common
> degrees minutes and seconds

"theorrix" <theorrix(a)discussions.microsoft.com> wrote in message
news:2C7C5BC7-B942-4529-9C68-84824A3AE87A(a)microsoft.com...
> How can i type into an excell cell with decimal degrees and get common
> degrees minutes and seconds

 | 
Pages: 1
Prev: loop through all worksheets
Next: Application.OnTime - Macro Cannot Be Found - Internet Explorer