hi,

i wonder how to change an angle to show in degree, minute,second instead of
degree in excel

i mean, for instance, make 45.5 (degree) to 45.3000 (d m s)

thanks

I'd start with Chip Pearson's site:
http://cpearson.com/excel/latlong.htm

EXCEL$B!!(BNEWS wrote:

hi,

i wonder how to change an angle to show in degree, minute,second instead of
degree in excel

i mean, for instance, make 45.5 (degree) to 45.3000 (d m s)

thanks

--

Dave Peterson

Here is one way...

DecimalDegrees = 45.5
DegreesMinutesSeconds = Int(DecimalDegrees) & Format((DecimalDegrees - _
Int(DecimalDegrees)) / 24, "\.nnss")

Rick


"EXCEL NEWS" wrote in message
...
hi,

i wonder how to change an angle to show in degree, minute,second instead
of degree in excel

i mean, for instance, make 45.5 (degree) to 45.3000 (d m s)

thanks

Thanks a lot

"Rick Rothstein (MVP - VB)" wrote in
message ...
Here is one way...

DecimalDegrees = 45.5
DegreesMinutesSeconds = Int(DecimalDegrees) & Format((DecimalDegrees - _
Int(DecimalDegrees)) / 24, "\.nnss")

Rick


"EXCEL NEWS" wrote in message
...
hi,

i wonder how to change an angle to show in degree, minute,second instead
of degree in excel

i mean, for instance, make 45.5 (degree) to 45.3000 (d m s)

thanks

You are welcome. As it turns out, we can simplify the expression somewhat..

DecimalDegrees = 45.5
DegreesMinutesSeconds = Int(DecimalDegrees) & _
Format(DecimalDegrees / 24, "\.nnss")

Rick


"EXCEL NEWS" wrote in message
...
Thanks a lot

"Rick Rothstein (MVP - VB)" wrote in
message ...
Here is one way...

DecimalDegrees = 45.5
DegreesMinutesSeconds = Int(DecimalDegrees) & Format((DecimalDegrees - _
Int(DecimalDegrees)) / 24, "\.nnss")

Rick


"EXCEL NEWS" wrote in message
...
hi,

i wonder how to change an angle to show in degree, minute,second
instead of degree in excel

i mean, for instance, make 45.5 (degree) to 45.3000 (d m s)

thanks