Let's say that in A1 we have 30.123456
this is a little more than 30 degrees.


In A2 put =A1/24
and format A2:
Format Cells... Number Custom and enter
[hh]°mm'ss\"
in place of
General
to see: 30°07'24"



--
Gary''s Student


"Mark" wrote:

Hello,
Is it possible to automaticly get a degree symbol in a cel once a type a
number?
It is possible with currency etc. under format cell and then number but i
can't find temperature anywhere.
Thanks in advance for the help.