Radians and Degrees

N

Nick

Is it possible to set Excel to use Degrees as the default format instead of Radians?

So that I can stop having to keep using the DEGREE and RADIAN functions to convert everything I do to perform calcs.
 
P

Peter Atherton

-----Original Message-----
Is it possible to set Excel to use Degrees as the default format instead of Radians?

So that I can stop having to keep using the DEGREE and
Click to expand...
RADIAN functions to convert everything I do to perform
calcs.
.
Click to expand...
Nick

I'm afraid not you could use a custom function to simplify
the task

Function mydegrees(d)
mydegrees = d / 57.29578
End Function

will convert degrees to radians (roughly)

e-mail [email protected]
regards
Peter
 
J

JE McGimpsey

You could define your own UDFs, e.g.:

Public Function DSin(dDegrees As Double) As Double
DSin = Sin(dDegrees * Application.Pi / 180)
End Function

call as

=DSin(30) ===> 0.5

If you're not familiar with UDFs, see David McRitchie's "Getting started
with macros and user defined functions":

http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top