is there a way to place the ± symbol on the tool bar so you can insert it
into text without going to the symbols and selecting it.
(the alt code won't work - using a notebook)

widman wrote on Wed, 23 May 2007 14:25:01 -0700:

w is there a way to place the ± symbol on the tool bar so you
w can insert it into text without going to the symbols and
w selecting it. (the alt code won't work - using a notebook)

Could you record a macro and place it on the bar? I've never
tried in Excel but I have done that sort of thing in Word and
even produced a button image for it. You could also auto-correct
something unlikely but easily remembered to ALT+ 0177.

James Silverton
Potomac, Maryland

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

You could create a button and assign a macro to do it. But the macro cannot
fire if you are already editing a cell, Excel doesn't hand over control at
that point.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"widman" wrote in message
...
is there a way to place the ± symbol on the tool bar so you can insert it
into text without going to the symbols and selecting it.
(the alt code won't work - using a notebook)

You can still use a notebook, usually you press the Fn key to get the numpad
equivalent

However you can also use insert. symbols



--
Regards,

Peo Sjoblom


"widman" wrote in message
...
is there a way to place the ± symbol on the tool bar so you can insert it
into text without going to the symbols and selecting it.
(the alt code won't work - using a notebook)

switching to the keypad in the middle of a formula or whatever on a notebook
to do an alt symbol, even if there is enough light to see the little grey
numbers is cumbersom and worse than the insert. That is why I said no to
that solution from the beginning.



"Peo Sjoblom" wrote:

You can still use a notebook, usually you press the Fn key to get the numpad
equivalent

However you can also use insert. symbols



--
Regards,

Peo Sjoblom


"widman" wrote in message
...
is there a way to place the ± symbol on the tool bar so you can insert it
into text without going to the symbols and selecting it.
(the alt code won't work - using a notebook)

What about insertsymbols then


--
Regards,

Peo Sjoblom



"widman" wrote in message
...
switching to the keypad in the middle of a formula or whatever on a
notebook
to do an alt symbol, even if there is enough light to see the little grey
numbers is cumbersom and worse than the insert. That is why I said no to
that solution from the beginning.



"Peo Sjoblom" wrote:

You can still use a notebook, usually you press the Fn key to get the
numpad
equivalent

However you can also use insert. symbols



--
Regards,

Peo Sjoblom


"widman" wrote in message
...
is there a way to place the ± symbol on the tool bar so you can insert
it
into text without going to the symbols and selecting it.
(the alt code won't work - using a notebook)

Wed, 23 May 2007 14:25:01 -0700 from widman
:
is there a way to place the ± symbol on the tool bar so you can insert it
into text without going to the symbols and selecting it.
(the alt code won't work - using a notebook)

Try prssing Fn and Alt at the same time, then typing 0177 and
releasing Alt and Fn. It works for me.

Alternatively, you could install something like Autohotkeys and tell
it to change +- into ±.

(Come to think of it, can you set up Excel's Autocorrect to change +-
into ±?)

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

widman wrote:
is there a way to place the ± symbol on the tool bar so you can insert it
into text without going to the symbols and selecting it.
(the alt code won't work - using a notebook)


I've been using a freeware called "AllChars" for many years.

http://allchars.zwolnet.com/

For your request, the key sequence would be ...

Cntrl + - = ±

It works _everywhere_

HTH

thanks all. i went with ''' in auto correct to change to ±

"bbelly" wrote:

widman wrote:
is there a way to place the ± symbol on the tool bar so you can insert it
into text without going to the symbols and selecting it.
(the alt code won't work - using a notebook)


I've been using a freeware called "AllChars" for many years.

http://allchars.zwolnet.com/

For your request, the key sequence would be ...

Cntrl + - = ±

It works _everywhere_

HTH

My new notebook is a wide screen with a numeric keypad next to the standard
alphabetic keypad. Though on my old one, holding the FN and ALT keys while
typing 0177 worked just fine.

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


"widman" wrote in message
...
switching to the keypad in the middle of a formula or whatever on a
notebook
to do an alt symbol, even if there is enough light to see the little grey
numbers is cumbersom and worse than the insert. That is why I said no to
that solution from the beginning.



"Peo Sjoblom" wrote:

You can still use a notebook, usually you press the Fn key to get the
numpad
equivalent

However you can also use insert. symbols



--
Regards,

Peo Sjoblom


"widman" wrote in message
...
is there a way to place the ± symbol on the tool bar so you can insert
it
into text without going to the symbols and selecting it.
(the alt code won't work - using a notebook)