getting a degree symbol (celsius) in each cell
It doesnt work
"Ron Coderre" wrote:
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.
|