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" wrote in message ...
|

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

regards
FSt1

"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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Trixie" wrote in message ...
|

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

Sun, 27 Jan 2008 13:36:12 +0100 from Niek Otten :
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/

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" wrote in message
t...
Sun, 27 Jan 2008 13:36:12 +0100 from Niek Otten :
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/

Trixie

Create a custom format for this.

FormatCellsNumberCustom

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
wrote:

On Sunday, January 27, 2008 2:36:01 PM UTC+3, Trixie wrote:


Thaxxx Stan brown