Change complete worksheet to degrees

[Scrungie]

Is there any way to change a worksheet so that all trig functions are expressed in degrees and not radians and I do not have to use the degrees function or use PI/180 or 180/PI individual cells.

[Dave Peterson]

I don't think you can do this.

There's no toggle for Degrees/Radians like on your calculator.

Scrungie wrote:
>
> Is there any way to change a worksheet so that all trig functions are
> expressed in degrees and not radians and I do not have to use the
> degrees function or use PI/180 or 180/PI individual cells.
>
> --
> Scrungie
> ------------------------------------------------------------------------
> Scrungie's Profile: http://www.excelforum.com/member.php...o&userid=16030
> View this thread: http://www.excelforum.com/showthread...hreadid=466839

--

Dave Peterson

[Gary''s Student]

Yes, but only in a limited number of circumstances

if your formulae are as simple as:

=sin(A1)

then use find
=sin(
and replace with
=sin(3.1415926/180*

WARNING this will not work with an arbitrary expression in:
=sin()
--
Gary''s Student


"Scrungie" wrote:

>
> Is there any way to change a worksheet so that all trig functions are
> expressed in degrees and not radians and I do not have to use the
> degrees function or use PI/180 or 180/PI individual cells.
>
>
> --
> Scrungie
> ------------------------------------------------------------------------
> Scrungie's Profile: http://www.excelforum.com/member.php...o&userid=16030
> View this thread: http://www.excelforum.com/showthread...hreadid=466839
>
>