View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
dougsan dougsan is offline
external usenet poster
 
Posts: 9
Default format cells in degrees & minutes of arc.

Its ok Ron the light is now turnd on

"Ron Rosenfeld" wrote:

On Sun, 22 Feb 2009 02:01:01 -0800, dougsan
wrote:

HI i think this is on the right track. but lets go one stage futher.

if the sum of the numbers are more than 360 then take 360 off but if the sum
is less than 360 leave it stand


And exactly what problem did you run into when you tried the suggestion.

Please post your input, actual output using the suggestion, and what you
expected.
--ron