How do I enter degrees, minutes, seconds

E

Edwn

I have an excal project that requires me to use degrees, minutes and seconds.
How do I enter this into a cell
 
J

jennifer

For the degrees go to insert menu and select symbol; make sure your font says
symbol and locate the degree symbol, press enter.
For the time, go to format menu and select cells, press the number tab and
select time and find the format you want to use.
 
A

AlfD

Hi!

When you have formatted a cell as [h]:mm:ss, enter your data as, for
example, 12:48:06.
You will then find you can calculate using the contents of the cell
(addind, multiplying etc).
 
Top