Can excel read numbers in the Sexagesimal system (DMS)?
 

Can excel read numbers in the Sexagesimal system (DMS)?

On Fri, 8 Apr 2005 21:23:03 -0700, George
wrote:

Can excel read numbers in the Sexagesimal system (DMS)?

So long as you use the decimal separator, Excel can convert your input to the
decimal equivalent.

If you have the Analysis ToolPak installed, you could use the DOLLARDE
function. e.g.

=DOLLARDE(A1,60).

If you do not have the ATP installed, then

=INT(A1)+MOD(A1,1)/0.6


--ron