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.

Automatically Adding a Degree Symbol in Excel

1. Select the cell or cells where you want to add the degree symbol.

1. Right-click and select "Format Cells" from the drop-down menu.

2. In the "Format Cells" dialog box, select the "Number" tab.
3. In the "Category" list, select "Custom."
4. In the "Type" field, enter the following format code: 5. Click "OK" to apply the format.

Now, whenever you type a number in the selected cell(s), it will automatically display with the degree symbol followed by "C" to indicate Celsius. You can also modify the format code to display Fahrenheit or other temperature units as needed.

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.

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.

Use the character map, copy the symbol. format cells use custom and paste as follows
#,##°

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Is there a question here or are you just sharing?


Gord Dibben MS Excel MVP

On Thu, 01 Feb 2007 13:46:06 -0800, me wrote:

Use the character map, copy the symbol. format cells use custom and paste as follows
#,##°

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

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.

Me;455006 Wrote:
It doesnt workit would if you used the number keypad to type 0176


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125950

On Mon, 17 Aug 2009 02:03:01 -0700, Me wrote:

It doesnt work

When you typed the 0176, was it on the numeric keypad? If not, try typing this
on the numeric keypad. If you did, review the entire sequence of keystrokes
and post back here exactly what you did.
--ron