If I know that a value in a cell is the TAN of an Angle, How do I

[Dr. Darrell]

I have types a formula into a cell which give me the a result which is the
TAN of my resultant Angle.

0.791233 = Tan 38.3522 Degrees

How do I express this in a formula so that my degrees are shown as the
resultant value?

Darrell

 

[Lamb Chop]

Right click the cell, Format Cell, Number (Custom), Type this in "Type":

tan ##.####

And at the last # sign press Alt key and press 0176 in the keypad.
Remember when you type 0176 this number, you must not use the alphabet
keyboard but the keypad.

Then Ok.

BTW, the convention of tangent is "tan" not "Tan"

Man

 

[paul]

=degrees(atan(.791233) will give you 38.35220785

 

[Dr. Darrell]

I'm not allowed to enter that format. The error message reads:

"Microsoft Office Excel cannot use the Number Format you Typed"

I tried:

tan ##.#### (alt 0176)
tan ##.####
tan##.####

I tried to format a cell that had a formula typed into it and I tried to
format a cell that only had a number typed into it.

Should there be "'s, _'s or ()'s?

Is there an option that needs to be turned on?

Darrell