Try this:

Select the cells to be impacted

From the Excel main menu:
<format<cells<number tab
Category: Custom
Type:
enter the word: General
....then hold down the [alt] key
....type 0176...release the [alt] key
....type a space
....type C
Click the [OK] button

That will make 21.5 display as: 21.5° C


Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP


"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.