PPRuNe Forums - View Single Post - Excel - formatting a cell number
View Single Post
Old 16th October 2006 | 19:48
  #2 (permalink)  
W.R.A.I.T.H
 
Joined: Aug 2006
Posts: 80
Likes: 0
From: pub
Excel is an a$$, I've spent like decades with it lately trying to persuade it to use angular format for some geodetic fun, and nearly lost my hair. I even designed a new format in VBA there, which for me is a feat unheard of, but it kept on giving trouble anyway. What I would do, were I brighter, would be to define my own format in VBA. But since I'm not, I just transform everything to decimal system, do calcs therein and transform it back to hour format at output.
W.R.A.I.T.H is offline  
Reply