software

What does it mean : 1/1/1900 6:00:00 AM, it has been used to get Degree
,Min, Sec , in the sheet
The cell is formatted to show the data as date/time. Excel stores these as
numbers starting at 1 Jan 1900. Your data appears to be 0.25 ie quarter of a
day, shown as 6AM on 1 Jan 1900.

What are you actually trying to achieve?

--
Ian
--
quot;Degree ,Min, Secquot; lt;Degree ,Min, gt; wrote in
message ...
gt; What does it mean : 1/1/1900 6:00:00 AM, it has been used to get Degree
gt; ,Min, Sec , in the sheet
gt;
gt;
Hi Degree Min Sec (and Ian),
It is a matter of formatting.
days (d), hours (h), minutes(m), seconds (s)
degrees (h), minutes (m), seconds(s)

You probably want to format your cell as [h]° mm' ss\quot;
the degree symbol is ALT 0176 on the numeric keypad.

More information and links in
: www.mvps.org/dmcritchie/rexx/...ls.htm#msexcel
also see Chip Pearson's quot;Latitude and Longitudequot;
www.cpearson.com/excel/latlong.htm

You would get a lot more out of newsgroups if you used your actual full name,
and a working email address. You can get a email address strictly for
newsgroups. You would also get a lot more out of newsgroups if
you first did a Google Groups search, and a Google web search.
www.mvps.org/dmcritchie/excel/xlnews.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Ianquot; gt; wrote in message ...
gt; The cell is formatted to show the data as date/time. Excel stores these as
gt; numbers starting at 1 Jan 1900. Your data appears to be 0.25 ie quarter of a
gt; day, shown as 6AM on 1 Jan 1900.
gt;
gt; What are you actually trying to achieve?
gt;
gt; --
gt; Ian
gt; --
gt; quot;Degree ,Min, Secquot; lt;Degree ,Min, gt; wrote in
gt; message ...
gt; gt; What does it mean : 1/1/1900 6:00:00 AM, it has been used to get Degree
gt; gt; ,Min, Sec , in the sheet
gt; gt;
gt; gt;
gt;
gt;