S
stew
Hi all
Like ,= , is there a Symbol that means , not equal.
Thanks For Looking
Stew
Like ,= , is there a Symbol that means , not equal.
Thanks For Looking
Stew
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
greater than
< less than
See help on "operators" for more of these.
Gord Dibben MS Excel MVP
M
Mike H
You require to symbols
<>
Mike
<>
Mike
J
James Silverton
Gord wrote on Sat, 14 Feb 2009 08:49:20 -0800:
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
< 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
S
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.
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.
J
James Silverton
Shane wrote on Sat, 14 Feb 2009 09:30:05 -0800:
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
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
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
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