| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Degrees
Hi All
I am trying to input Degrees/minutes/seconds in the one cell. I have setup a custom format thus: [h]°:mm':ss'' However, when I type in 017°30'20'' I get 4152480°:00':00'' What am I doing wrong. All I really want to do is type in 0173020 as a number and have excel make it look like 017°:30':20'' Any help would be appeciated Regards Michael M |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column heading at 45 degrees | Excel Discussion (Misc queries) | |||
| degrees formula | Excel Worksheet Functions | |||
| convert decimal degrees to degrees minutes seconds | Excel Discussion (Misc queries) | |||
| excel formula to convert lat/lon degrees to DDD MM SS.SS? | Excel Worksheet Functions | |||
| converting from digital degrees to degrees minutes seconds | Excel Worksheet Functions | |||
Threaded Mode
