how do you write the degrees symbol in excel?

[Trixie]

 

[Niek Otten]

Press and hold the ALT key, on the numeric keypad, type 0186, release the ALT key
It may depend on which font you use. It certainly works for popular fonts like Arial and Times New Roman

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|

 

[FSt1]

hi
another way...
=86&char(186)
leave as is or copy and paste as values.

regards
FSt1

 

[James Silverton]

FSt1 wrote on Sun, 27 Jan 2008 04:55:00 -0800:

F> regards
F> FSt1

F> "Niek Otten" wrote:

??>> Press and hold the ALT key, on the numeric keypad, type
??>> 0186, release the ALT key It may depend on which font you
??>> use. It certainly works for popular fonts like Arial and
??>> Times New Roman

Altho' all the above prescriptions work, and may be useful in
some of Excel's peculiar situations, I use the degree symbol
quite a bit in Word. Sometimes, I can remember ALT+0186 or use
the Character Map program but I think the most practical way is
to use Autocorrect. The same Autocorrect, set up in Word, works
in Excel. I use ~o, which I usually can remember. I find that a
similar route is useful for temperatures; in my case ~F and ~C.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

 

[James Silverton]

James wrote to FSt1 on Sun, 27 Jan 2008 08:14:04 -0500:

JS> I think the
JS> most practical way is to use Autocorrect. The same
JS> Autocorrect, set up in Word, works in Excel. I use ~o,
JS> which I usually can remember. I find that a similar route
JS> is useful for temperatures; in my case ~F and ~C.

Sorry, that's my usual route but, of course, Autocorrect is
available on the Tools menu in Excel too!

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

 

[Stan Brown]

Press and hold the ALT key, on the numeric keypad, type 0186,
release the ALT key

Alt-0176, surely? Alt-0186 gives the masculine ordinal symbol º.

 

[Jon Peltier]

My muscles remember ALT+0176 (°), so I tried both, and agree that 0176 is
the proper code.

- Jon

 

[Gord Dibben]

Trixie

Create a custom format for this.

Format>Cells>Number>Custom

Type a zero(0) then Alt + 0176 on the numpad

Or 0.0 and Alt + 0176 for 1 decimal place


Gord Dibben MS Excel MVP

 

[muhammadali1319]

Thaxxx Stan brown