View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Topcon Ben Topcon Ben is offline
external usenet poster
 
Posts: 1
Default How do I represent values in Degrees Minutes Seconds in Excel?

I need to format the results of a =DEGREES(ATAN(x)) formula to be in Degrees
Minutes Seconds format. I don't want to have to do decimal degrees, not put
the results in 3 different columns (which I have done in the past).