View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lamb Chop Lamb Chop is offline
external usenet poster
 
Posts: 38
Default If I know that a value in a cell is the TAN of an Angle, How do I

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



"Dr. Darrell" wrote in message
...
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