the 'degree' symbol

Does anyone have a good way of getting the 'degree' symbol into a series of
cells?
Either farenheit or celcius...doesn't matter...i just want the symbol.

Dave French

JulieD
Tue Apr 26 09:46:12 CDT 2005

Hi David

either insert / symbol - it's under the "symbol" font

or hold down ALT and type 0186

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"David French" <nospam@nospam.com> wrote in message
news:eTw8%233mSFHA.3704@TK2MSFTNGP12.phx.gbl...
> Does anyone have a good way of getting the 'degree' symbol into a series
> of cells?
> Either farenheit or celcius...doesn't matter...i just want the symbol.
>
> Dave French
>

Don
Tue Apr 26 09:46:51 CDT 2005

123alt0186

--
Don Guillett
SalesAid Software
donaldb@281.com
"David French" <nospam@nospam.com> wrote in message
news:eTw8%233mSFHA.3704@TK2MSFTNGP12.phx.gbl...
> Does anyone have a good way of getting the 'degree' symbol into a series
of
> cells?
> Either farenheit or celcius...doesn't matter...i just want the symbol.
>
> Dave French
>
>

Andy
Tue Apr 26 09:50:12 CDT 2005

Hi
You could try
=CHAR(176)

--
Andy.


"David French" <nospam@nospam.com> wrote in message
news:eTw8%233mSFHA.3704@TK2MSFTNGP12.phx.gbl...
> Does anyone have a good way of getting the 'degree' symbol into a series
> of cells?
> Either farenheit or celcius...doesn't matter...i just want the symbol.
>
> Dave French
>

Guillermo
Tue Apr 26 09:59:47 CDT 2005

I think alt + 0176 is a better degree symbol than alt + 0186

remember to use the numeric keypad

guillemro

"David French" <nospam@nospam.com> wrote in message
news:eTw8%233mSFHA.3704@TK2MSFTNGP12.phx.gbl...
> Does anyone have a good way of getting the 'degree' symbol into a series
of
> cells?
> Either farenheit or celcius...doesn't matter...i just want the symbol.
>
> Dave French
>
>

Guillermo
Tue Apr 26 10:09:37 CDT 2005

well, I guess in excel is almost the same. I tried it in matlab (sometimes I
try to help in a couple of newgroups and get confused which one I'm looking
at), and 0186 is better because the 0176 shows as the ordinals symbol (with
a line at the bottom).

"Guillermo" <gmozavala@hotmail.com> wrote in message
news:%23XEAIBnSFHA.3988@tk2msftngp13.phx.gbl...
> I think alt + 0176 is a better degree symbol than alt + 0186
>
> remember to use the numeric keypad
>
> guillemro
>
> "David French" <nospam@nospam.com> wrote in message
> news:eTw8%233mSFHA.3704@TK2MSFTNGP12.phx.gbl...
> > Does anyone have a good way of getting the 'degree' symbol into a series
> of
> > cells?
> > Either farenheit or celcius...doesn't matter...i just want the symbol.
> >
> > Dave French
> >
> >
>
>

Don
Tue Apr 26 10:07:03 CDT 2005

0176 it is

--
Don Guillett
SalesAid Software
donaldb@281.com
"Guillermo" <gmozavala@hotmail.com> wrote in message
news:%23XEAIBnSFHA.3988@tk2msftngp13.phx.gbl...
> I think alt + 0176 is a better degree symbol than alt + 0186
>
> remember to use the numeric keypad
>
> guillemro
>
> "David French" <nospam@nospam.com> wrote in message
> news:eTw8%233mSFHA.3704@TK2MSFTNGP12.phx.gbl...
> > Does anyone have a good way of getting the 'degree' symbol into a series
> of
> > cells?
> > Either farenheit or celcius...doesn't matter...i just want the symbol.
> >
> > Dave French
> >
> >
>
>

Gord
Tue Apr 26 10:14:29 CDT 2005

David

If you need the temperatures in number form for calcualtions you will have to
add a Custom Format rather than in-cell editing.

Format>Cells>Custom. Select the 0 format and click in dialog box to edit.

###.0(ALT + 0176)"F"

Steps...enter the ###.0 then on Numpad(gray keys) enter ALT + 0176 then "F" or
"C" and you're done.


Gord Dibben Excel MVP

On Tue, 26 Apr 2005 10:41:07 -0400, "David French" <nospam@nospam.com> wrote:

>Does anyone have a good way of getting the 'degree' symbol into a series of
>cells?
>Either farenheit or celcius...doesn't matter...i just want the symbol.
>
>Dave French
>

David
Tue Apr 26 13:15:24 CDT 2005

OK that's great in theory.
When I put it in the ALT+0176 appears literal in the cells instead of the
degree symbol.

Dave

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:ukms61156pofbpugmpca5uunbok9ebiut3@4ax.com...
> David
>
> If you need the temperatures in number form for calcualtions you will have
> to
> add a Custom Format rather than in-cell editing.
>
> Format>Cells>Custom. Select the 0 format and click in dialog box to edit.
>
> ###.0(ALT + 0176)"F"
>
> Steps...enter the ###.0 then on Numpad(gray keys) enter ALT + 0176 then
> "F" or
> "C" and you're done.
>
>
> Gord Dibben Excel MVP
>
> On Tue, 26 Apr 2005 10:41:07 -0400, "David French" <nospam@nospam.com>
> wrote:
>
>>Does anyone have a good way of getting the 'degree' symbol into a series
>>of
>>cells?
>>Either farenheit or celcius...doesn't matter...i just want the symbol.
>>
>>Dave French
>>
>

Gord
Tue Apr 26 13:27:35 CDT 2005

David

Do not enter the literal characters "ALT + 0176"

Just hold the ALT key and hit 0176 on NumPad.

With a number in a cell go to Format>Number>Custom

Clear the Custom dialog box then enter literal ###.0 then hold ALT key and hit
0176 then enter the literal "F" or "C"(include the quotes).

Watch what happens to the value of the cell in the preview window.


Gord

On Tue, 26 Apr 2005 14:15:24 -0400, "David French" <nospam@nospam.com> wrote:

>OK that's great in theory.
>When I put it in the ALT+0176 appears literal in the cells instead of the
>degree symbol.
>
>Dave
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:ukms61156pofbpugmpca5uunbok9ebiut3@4ax.com...
>> David
>>
>> If you need the temperatures in number form for calcualtions you will have
>> to
>> add a Custom Format rather than in-cell editing.
>>
>> Format>Cells>Custom. Select the 0 format and click in dialog box to edit.
>>
>> ###.0(ALT + 0176)"F"
>>
>> Steps...enter the ###.0 then on Numpad(gray keys) enter ALT + 0176 then
>> "F" or
>> "C" and you're done.
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Tue, 26 Apr 2005 10:41:07 -0400, "David French" <nospam@nospam.com>
>> wrote:
>>
>>>Does anyone have a good way of getting the 'degree' symbol into a series
>>>of
>>>cells?
>>>Either farenheit or celcius...doesn't matter...i just want the symbol.
>>>
>>>Dave French
>>>
>>
>

David
Tue Apr 26 14:32:01 CDT 2005

Some additional notes:

On a desktop the degree symbol is typed ALT+0176 on the
numeric keypad with NumLock on. The ALT key on US keyboards
is immediately to the left of the SpaceBar and the the Right of the
spacebar. On at least some European keyboard there is a
distinction between the two keys.

On a laptop use Fn+Alt+0176 on numeric keypad with NumLock off.

For more information on symbols in Excel, and HTML see
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"David French" <nospam@nospam.com> wrote in message news:uGTfrvoSFHA.3664@TK2MSFTNGP15.phx.gbl...
> OK that's great in theory.
> When I put it in the ALT+0176 appears literal in the cells instead of the
> degree symbol.
>
> Dave
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:ukms61156pofbpugmpca5uunbok9ebiut3@4ax.com...
> > David
> >
> > If you need the temperatures in number form for calcualtions you will have
> > to
> > add a Custom Format rather than in-cell editing.
> >
> > Format>Cells>Custom. Select the 0 format and click in dialog box to edit.
> >
> > ###.0(ALT + 0176)"F"
> >
> > Steps...enter the ###.0 then on Numpad(gray keys) enter ALT + 0176 then
> > "F" or
> > "C" and you're done.
> >
> >
> > Gord Dibben Excel MVP
> >
> > On Tue, 26 Apr 2005 10:41:07 -0400, "David French" <nospam@nospam.com>
> > wrote:
> >
> >>Does anyone have a good way of getting the 'degree' symbol into a series
> >>of
> >>cells?
> >>Either farenheit or celcius...doesn't matter...i just want the symbol.
> >>
> >>Dave French
> >>
> >
>
>

Beege
Tue Apr 26 14:56:52 CDT 2005

And how do you feel about ALT + 248? °

Beege


"Guillermo" <gmozavala@hotmail.com> wrote in message
news:%23XEAIBnSFHA.3988@tk2msftngp13.phx.gbl...
>I think alt + 0176 is a better degree symbol than alt + 0186
>
> remember to use the numeric keypad
>
> guillemro
>
> "David French" <nospam@nospam.com> wrote in message
> news:eTw8%233mSFHA.3704@TK2MSFTNGP12.phx.gbl...
>> Does anyone have a good way of getting the 'degree' symbol into a series
> of
>> cells?
>> Either farenheit or celcius...doesn't matter...i just want the symbol.
>>
>> Dave French
>>
>>
>
>

Sandy
Tue Apr 26 16:24:53 CDT 2005

I feel it looks like the *Theta* symbol on my laptop

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Beege" <bwgilman__@hotmail.com> wrote in message
news:jYCdnXASGsiZAPPfRVn-tQ@comcast.com...
> And how do you feel about ALT + 248? °
>
> Beege
>
>
> "Guillermo" <gmozavala@hotmail.com> wrote in message
> news:%23XEAIBnSFHA.3988@tk2msftngp13.phx.gbl...
> >I think alt + 0176 is a better degree symbol than alt + 0186
> >
> > remember to use the numeric keypad
> >
> > guillemro
> >
> > "David French" <nospam@nospam.com> wrote in message
> > news:eTw8%233mSFHA.3704@TK2MSFTNGP12.phx.gbl...
> >> Does anyone have a good way of getting the 'degree' symbol into a
series
> > of
> >> cells?
> >> Either farenheit or celcius...doesn't matter...i just want the symbol.
> >>
> >> Dave French
> >>
> >>
> >
> >
>
>

David
Tue Apr 26 16:41:21 CDT 2005

Okay, but why does Alt+248 without the leading zero
equate to Alt+0176 (with the leading zero)

"Beege" <bwgilman__@hotmail.com> wrote
> And how do you feel about ALT + 248? °

David
Tue Apr 26 16:49:22 CDT 2005

lowercase phi in my dictionary but that is if you type Alt+0248
instead of phi Alt+248

"Sandy Mann" <sandymann@mailinator.com> wrote ...
> I feel it looks like the *Theta* symbol on my laptop
>

David
Tue Apr 26 17:02:49 CDT 2005

always a little garbage left <grin> should have said
> instead of Alt+248

Sandy
Tue Apr 26 17:48:34 CDT 2005

> lowercase phi in my dictionary

It's all Greek to me <g>

> ...................but that is if you type Alt+0248
> instead of phi Alt+248


Yes, I shall have to learn to read in English as well!

The strange thing is when I enter Alt+248 in A1 and then test it with
=CODE(A1) I get 176 returned?

Sandy


--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"David McRitchie" <dmcritchie@msn.com> wrote in message
news:%23PJ1$nqSFHA.580@TK2MSFTNGP15.phx.gbl...
> lowercase phi in my dictionary but that is if you type Alt+0248
> instead of phi Alt+248
>
> "Sandy Mann" <sandymann@mailinator.com> wrote ...
> > I feel it looks like the *Theta* symbol on my laptop
> >
>
>

Dana
Tue Apr 26 17:59:52 CDT 2005

Just for gee wiz... Under Insert | symbol, if one selects character 176, the
name of this character is displayed in the lower left corner. The name of
Char 176 is listed as "DEGREE SIGN"
Just for a comparison to Matlab, Mathematica's default Character encoding
for the Degree Unit symbol is also 176.

--
Dana DeLouis
Win XP & Office 2003


"Guillermo" <gmozavala@hotmail.com> wrote in message
news:eAthnGnSFHA.336@TK2MSFTNGP09.phx.gbl...
> well, I guess in excel is almost the same. I tried it in matlab (sometimes
> I
> try to help in a couple of newgroups and get confused which one I'm
> looking
> at), and 0186 is better because the 0176 shows as the ordinals symbol
> (with
> a line at the bottom).
>
> "Guillermo" <gmozavala@hotmail.com> wrote in message
> news:%23XEAIBnSFHA.3988@tk2msftngp13.phx.gbl...
>> I think alt + 0176 is a better degree symbol than alt + 0186
>>
>> remember to use the numeric keypad
>>
>> guillemro
>>
>> "David French" <nospam@nospam.com> wrote in message
>> news:eTw8%233mSFHA.3704@TK2MSFTNGP12.phx.gbl...
>> > Does anyone have a good way of getting the 'degree' symbol into a
>> > series
>> of
>> > cells?
>> > Either farenheit or celcius...doesn't matter...i just want the symbol.
>> >
>> > Dave French
>> >
>> >
>>
>>
>
>

Gary
Tue Apr 26 23:51:43 CDT 2005

Characters entered with the leading zero are interpreted as being in the
so-called ANSI character set, where character 248 is Latin small o with
slash. Characters entered without the leading zero are interpreted as
being in the default codepage ("OEM" character set) and are remapped to
ANSI. The most commonly used code pages are 437 and 850. In both of
these, character 248 is the degree symbol. When you enter Alt+248,
Windows changes the value 248 to 176, so what you see is the degree symbol
Windows assumes you meant.

The difference between using and omitting the leading zero applies only
when the OEM character also exists in the ANSI set, but in a different
position. Thus Alt+176 and Alt+0176 do the same thing because character
176 in CP 437 and 850 is a drawing charcter not present in the ANSI set.



David McRitchie <dmcritchie@msn.com> wrote:
> Okay, but why does Alt+248 without the leading zero
> equate to Alt+0176 (with the leading zero)

> "Beege" <bwgilman__@hotmail.com> wrote
>> And how do you feel about ALT + 248? ?


--
Gary L. Smith gls432@yahoo.com
Columbus, Ohio

AndreaJones
Wed Apr 27 06:40:05 CDT 2005

If you're trying to display figures as degrees you should just type the
number in the cell and then set a custom format to make that value look like
degrees. Type your value in the cell then click on the cell and press CTRL+1
or click on Format->Cells. Click on the Number tab at the top of the window
and then click on Custom in the list on the left, type the following in the
box at the top on the right-hand side:

#.00 ALT+0176

(hold down the ALT key on your keyboard while typing 0176 on the keyboard's
number pad to get the last part of the expression, when you release ALT you
will see a degrees sign). When you click OK the cell will be formatted with
a degree symbol, you can then use the same custom format to format other
cells and will still be able to use the cell contents in calculations.

See http://www.allaboutoffice.co.uk/excustf.htm for more information on
creating custom formats.

Andrea Jones

"David French" wrote:

> Does anyone have a good way of getting the 'degree' symbol into a series of
> cells?
> Either farenheit or celcius...doesn't matter...i just want the symbol.
>
> Dave French
>
>
>

David
Wed Apr 27 11:33:56 CDT 2005

Thanks for the explanation Gary of the difference between
ALT+nnnn and ALT+nnn, the following shows what
you mentioned (CP 437 and CP 850 have the box drawing characters).
MS-DOS Codepage 850 (Multilingual Latin 1)
http://www.kostis.net/charsets/cp850.htm
http://www.kostis.net/charsets/cp437.htm

which we would not be seeing in the
Microsoft Windows Codepage 1252 (ANSI)
http://www.kostis.net/charsets/cp1252.htm
Table shown with hex digits
Windows Code Page 1252
http://www.microsoft.com/globaldev/reference/sbcs/1252.htm


"Gary Smith" <bitbucket@example.com> wrote in message news:OrkyPTuSFHA.548@tk2msftngp13.phx.gbl...
> Characters entered with the leading zero are interpreted as being in the
> so-called ANSI character set, where character 248 is Latin small o with
> slash. Characters entered without the leading zero are interpreted as
> being in the default codepage ("OEM" character set) and are remapped to
> ANSI. The most commonly used code pages are 437 and 850. In both of
> these, character 248 is the degree symbol. When you enter Alt+248,
> Windows changes the value 248 to 176, so what you see is the degree symbol
> Windows assumes you meant.
>
> The difference between using and omitting the leading zero applies only
> when the OEM character also exists in the ANSI set, but in a different
> position. Thus Alt+176 and Alt+0176 do the same thing because character
> 176 in CP 437 and 850 is a drawing charcter not present in the ANSI set.
>
>
>
> David McRitchie <dmcritchie@msn.com> wrote:
> > Okay, but why does Alt+248 without the leading zero
> > equate to Alt+0176 (with the leading zero)
>
> > "Beege" <bwgilman__@hotmail.com> wrote
> >> And how do you feel about ALT + 248? ?
>
>
> --
> Gary L. Smith gls432@yahoo.com
> Columbus, Ohio