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

S

scott

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

Degrees symbol in worksheet(EXCEL) wrote:
 
F

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
 
D

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.
:>)
 
R

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.
:>)
Click to expand...

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


--ron
 
D

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! :>(
 
R

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! :>(
Click to expand...

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
 
D

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. :>)
 
Top