Hi all
Like ,= , is there a Symbol that means , not equal.

Thanks For Looking

Stew

< means not equal.

greater than

< less than

See help on "operators" for more of these.


Gord Dibben MS Excel MVP

On Sat, 14 Feb 2009 08:40:00 -0800, stew
wrote:

Hi all
Like ,= , is there a Symbol that means , not equal.

Thanks For Looking

Stew

You require to symbols

<

Mike

"stew" wrote:

Hi all
Like ,= , is there a Symbol that means , not equal.

Thanks For Looking

Stew

thank you both

Stew

"Gord Dibben" wrote:

< means not equal.

greater than

< less than

See help on "operators" for more of these.


Gord Dibben MS Excel MVP

On Sat, 14 Feb 2009 08:40:00 -0800, stew
wrote:

Hi all
Like ,= , is there a Symbol that means , not equal.

Thanks For Looking

Stew

Gord wrote on Sat, 14 Feb 2009 08:49:20 -0800:

greater than

< less than

See help on "operators" for more of these.

Gord Dibben MS Excel MVP

On Sat, 14 Feb 2009 08:40:00 -0800, stew
wrote:

Hi all
Like ,= , is there a Symbol that means , not equal.

Thanks For Looking

Stew

Certainly correct for formulas but, except for autocorrect, I don't know
how to insert the Unicode "not equal" symbol (a slanted bar across the
equal sign) in Excel. It can be done in Word, thereby possibly setting
up an autocorrect since a Unicode symbol may be inserted as its number
(here 2260) followed by ALT-X
--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

Hi,

1. In Excel choose Insert, Symbol, from the Font drop down pick Symbol,
scroll down to find it, its symbol 185.

2. You can type =CHAR(185) in a cell and then format the cell with the
Symbol font set.

3. There will be and Alt+ Number Key Pad combination, but I can't test it
easily on my laptop.

4. In Excel 2007 choose Insert, Symbol and with Font of Arial and Unicode
(hex) selected it far down, character code 2260.

Of course none of these will be useful in formulas.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"James Silverton" wrote:

Gord wrote on Sat, 14 Feb 2009 08:49:20 -0800:

greater than

< less than

See help on "operators" for more of these.

Gord Dibben MS Excel MVP

On Sat, 14 Feb 2009 08:40:00 -0800, stew
wrote:

Hi all
Like ,= , is there a Symbol that means , not equal.

Thanks For Looking

Stew

Certainly correct for formulas but, except for autocorrect, I don't know
how to insert the Unicode "not equal" symbol (a slanted bar across the
equal sign) in Excel. It can be done in Word, thereby possibly setting
up an autocorrect since a Unicode symbol may be inserted as its number
(here 2260) followed by ALT-X
--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

Shane wrote on Sat, 14 Feb 2009 09:30:05 -0800:

1. In Excel choose Insert, Symbol, from the Font drop down
pick Symbol, scroll down to find it, its symbol 185.

2. You can type =CHAR(185) in a cell and then format the cell
with the Symbol font set.

3. There will be and Alt+ Number Key Pad combination, but I
can't test it easily on my laptop.

4. In Excel 2007 choose Insert, Symbol and with Font of Arial
and Unicode (hex) selected it far down, character code 2260.

Of course none of these will be useful in formulas.


"James Silverton" wrote:

Gord wrote on Sat, 14 Feb 2009 08:49:20 -0800:

greater than

< less than

See help on "operators" for more of these.

Gord Dibben MS Excel MVP

On Sat, 14 Feb 2009 08:40:00 -0800, stew
wrote:

Hi all
Like ,= , is there a Symbol that means , not equal.

Thanks For Looking

Stew

Certainly correct for formulas but, except for autocorrect, I
don't know how to insert the Unicode "not equal" symbol (a
slanted bar across the equal sign) in Excel. It can be done
in Word, thereby possibly setting up an autocorrect since a
Unicode symbol may be inserted as its number (here 2260)
followed by ALT-X --

Thanks Shane. I had missed the ALT+0185 symbol and the Unicode method
works even in Excel 2002. Part of my problem was that I had NUM-LOCK
switched off and, even if it is on, the plain text format that I use in
Outlook Express gives superscript 1 (¹) for ALT+0185. I can copy a not
equal symbol to OE but I don't think I can transmit it in plain text.

Autocorrect is the same for Excel and Word and I find it useful for
commonly used symbols. Currently, I use .ne. to correct to the not equal
symbol since I do need < for formulas.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not