Symbol

[stew]

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

Thanks For Looking

Stew

 

[Gord Dibben]

greater than

< less than

See help on "operators" for more of these.


Gord Dibben MS Excel MVP

 

[Mike H]

You require to symbols

<>

Mike

 

[James Silverton]

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

< 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

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

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.

 

[James Silverton]

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:

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

 

[AndyKay]

Send.keys

How do you send the <Alt> key command to Excel using DDE?

I am attempting to find a work around to Microsofts absence of a Macro for Data Validation. I am attempting to send the Alt+ commands to open the Data Validation window, but all attempts have failed. The language I'm using can best be described as a 40-50 year old programming language that is very similar to BASIC code, so I can't use SUB, DIM, or anything like that.

Another language is out of the question, too.

TIA.

AK