How can I insert degrees symbol in worksheet(EXCEL)?

[Guest]

 

[scott]

Press the <ALT>
key while typing
this number ... 0176

Degrees symbol in worksheet(EXCEL) wrote:

 

[Alex Delamain]

Use Alt and 0186 together


if A1 = 20 then =A1&"ALT0186C" gives 20ºC

 

[Alex Delamain]

Scott
at the risk of lowering the tone ....
mine's bigger than yours!!!

 

[Ron Rosenfeld]

Scott
at the risk of lowering the tone ....
mine's bigger than yours!!!

What font? They seem to be the same size in my usual fonts.


--ron

 

[Frank Stone]

hi,
In a blank workbook at a1 enter =char(row()) and copy down
to 255. you will have all kinds of special characters.
degree is 186 i think. so degree would be =Char(186)
you can use the alt+0186 to do the same thing. you can
also use the alt+ the other special charicters numbers as
mentioned above using the =char(row()) but you have to
know the numbers.
regards
Frank

 

[scott]

Don't know? I'm using netscape messenger, so everything is the same font.

 

[Dana DeLouis]

Just for discussion...Using Insert | Symbol, char 176 is called the "Degree
Sign", and char 186 is called something I've never heard of "Masculine
Ordinal Indec.." In Arial Font, my 186 char is slightly bigger, more oval,
and bolder. My 176 char is circular...like a Degree Sign.
Again...just gee-wiz.
:>)

 

[Dave Peterson]

If you make that form a little larger, you'll see "masculine ordinal indicator".

And because I have no idea what that means:

http://encyclopedia.thefreedictionary.com/ordinal indicator
and
http://encyclopedia.thefreedictionary.com/%BA

Thank you google!

 

[Ron Rosenfeld]

Just for discussion...Using Insert | Symbol, char 176 is called the "Degree
Sign", and char 186 is called something I've never heard of "Masculine
Ordinal Indec.." In Arial Font, my 186 char is slightly bigger, more oval,
and bolder. My 176 char is circular...like a Degree Sign.
Again...just gee-wiz.
:>)

Ah, OK. Your eyes are better than mine <g>


--ron

 

[lsu-i-like]

the batang font has a crapload of characters

 

[Dana DeLouis]

Ah, OK. Your eyes are better than mine <g>

Not really. Every year I seem to like bigger zoom settings. ;>0 I'll be
at 400% zoom pretty soon I'm sure. <g> I already know where the Windows
"Magnifier" utility is. It's under "Windows Key" + "U" then start
"Magnifier." It's so sad! :>(

 

[Ron Rosenfeld]

Not really. Every year I seem to like bigger zoom settings. ;>0 I'll be
at 400% zoom pretty soon I'm sure. <g> I already know where the Windows
"Magnifier" utility is. It's under "Windows Key" + "U" then start
"Magnifier." It's so sad! :>(

Neat. That's something I've never used, or thought about. I probably knew it
existed at one time but ... (it's that age thing).

In any event, I started it up. My computer started to talk to me in a
"computer" voice, reading everything on the screen ), and I did see clearly
the difference between <alt-0176> ° and <alt-0186> º although in whatever font
Agent is using, there is no difference.


--ron

 

[Dana DeLouis]

I just noticed that you can change the magnification level from 2 to 9!!
With Excel set at 400% zoom, a cell was now bigger than the width of my
monitor. Wow. That's really zoomed in. I didn't know the following...
With one background color in A1, and a different background color in B2, at
the "Micron" level, B2's color overlaps A1's color at the corner. (useless
info I know)

Hopefully we've got a few good years left before this is necessary. One
thing I find myself often using is holding the Ctrl key, and using the
scroll wheel on my IntelliMouse to zoom in and out in Excel. :>)

 

[Alex Delamain]

ok - now I definitely know that some people don't have enough work t
do!
:

 

[Ron Rosenfeld]

ok - now I definitely know that some people don't have enough work to
do!

Hey, I'm retired. I don't do *anything* !!


--ron