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
--
"Degree ,Min, Sec" <Degree ,Min, wrote in
message ...
What does it mean : 1/1/1900 6:00:00 AM, it has been used to get Degree
,Min, Sec , in the sheet

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\"
the degree symbol is ALT+0176 on the numeric keypad.

More information and links in
: http://www.mvps.org/dmcritchie/rexx/...ls.htm#msexcel
also see Chip Pearson's "Latitude and Longitude"
http://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.
http://www.mvps.org/dmcritchie/excel/xlnews.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ian" wrote in message ...
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
--
"Degree ,Min, Sec" <Degree ,Min, wrote in
message ...
What does it mean : 1/1/1900 6:00:00 AM, it has been used to get Degree
,Min, Sec , in the sheet