Degree ,Min, Sec
What does it mean : 1/1/1900 6:00:00 AM, it has been used to get Degree
,Min, Sec , in the sheet |
Degree ,Min, Sec
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 |
Degree ,Min, Sec
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 |
All times are GMT +1. The time now is 08:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com