Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

how do you write the degrees symbol in excel?

3,382 views
Skip to first unread message

Trixie

unread,
Jan 27, 2008, 6:36:01 AM1/27/08
to

Niek Otten

unread,
Jan 27, 2008, 7:36:12 AM1/27/08
to
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

"Trixie" <Tri...@discussions.microsoft.com> wrote in message news:C851F151-4F60-4F7E...@microsoft.com...
|


FSt1

unread,
Jan 27, 2008, 7:55:00 AM1/27/08
to
hi
another way...
=86&char(186)
leave as is or copy and paste as values.

regards
FSt1

James Silverton

unread,
Jan 27, 2008, 8:14:04 AM1/27/08
to
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

unread,
Jan 27, 2008, 8:24:11 AM1/27/08
to
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!

Stan Brown

unread,
Jan 27, 2008, 8:47:50 AM1/27/08
to
Sun, 27 Jan 2008 13:36:12 +0100 from Niek Otten <nico...@xs4all.nl>:

> 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 º.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

Jon Peltier

unread,
Jan 27, 2008, 10:27:39 AM1/27/08
to
My muscles remember ALT+0176 (°), so I tried both, and agree that 0176 is
the proper code.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Stan Brown" <the_sta...@fastmail.fm> wrote in message
news:MPG.220655968...@news.individual.net...

Gord Dibben

unread,
Jan 27, 2008, 12:54:34 PM1/27/08
to
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

On Sun, 27 Jan 2008 03:36:01 -0800, Trixie <Tri...@discussions.microsoft.com>
wrote:


muhamma...@gmail.com

unread,
May 19, 2013, 6:51:27 AM5/19/13
to
On Sunday, January 27, 2008 2:36:01 PM UTC+3, Trixie wrote:
>

Thaxxx Stan brown
0 new messages