--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Trixie" <Tri...@discussions.microsoft.com> wrote in message news:C851F151-4F60-4F7E...@microsoft.com...
|
regards
FSt1
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
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!
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
-------
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...
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: