Radians and Degrees

[Guest]

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.

 

[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

RADIAN functions to convert everything I do to perform
calcs.

.

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 (e-mail address removed)
regards
Peter

 

[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