View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bablefish Bablefish is offline
external usenet poster
 
Posts: 1
Default how can I add degrees? ie 300degrees + 100 degrees = 40 degrees

I want to add magnetic headings. I need to enter the degrees as 3 figures. ie
045
I have found that I can do that when I add the degree sybmol to the figure.
But when I try to use the sum command, it wont add because the field
contains the symbol.