NavList:

   

Reply

Peter, and others
Not being a person that can program an Excel spreadsheet, I am not even sure 
how to ask the question. In my copy of Excel, using the dialog box for 
formatting cells I see you can define an input field as ?custom? and have 
input in combinations of time and number. That is to say, enter a number + 
minuets, and seconds (##0 MM SS) or just HHH MM SS using that custom mask. 
Why can?t the spreadsheet you wrote use time as a stand-in for degrees, 
minuets and seconds of an angle. The spreadsheet understands that a minuet 
and a second have 60 integers in them so it would seem like you can trick it 
into using that input mask to make a user friendly front end. If I understand 
it correctly, you can unstring the data to use in calculations later in the 
spreadsheet so it looks doable in the company of a sufficient amount of 
ignorance on my part.
Thanks,
Robert Gainer

   

Reply