ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   typing a complement (i.e. notA) character in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/108188-typing-complement-i-e-nota-character-excel.html)

jheby

typing a complement (i.e. notA) character in Excel
 
Is there any way to type the math convention of a complement in Excel (an X
with a line above it)? I need it to appear correct both on the screen and
when printed.

Debra Dalgleish

typing a complement (i.e. notA) character in Excel
 
Format the cell with Symbol font, and an odd-numbered font size, e.g. 9
or 11
Hold the Alt key, and on the number keypad, type 0096
Release the Alt key, and type an upper case C
Press Enter, to complete the entry


jheby wrote:
Is there any way to type the math convention of a complement in Excel (an X
with a line above it)? I need it to appear correct both on the screen and
when printed.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


jheby

typing a complement (i.e. notA) character in Excel
 
That works great - thanks a bunch!

"Debra Dalgleish" wrote:

Format the cell with Symbol font, and an odd-numbered font size, e.g. 9
or 11
Hold the Alt key, and on the number keypad, type 0096
Release the Alt key, and type an upper case C
Press Enter, to complete the entry


jheby wrote:
Is there any way to type the math convention of a complement in Excel (an X
with a line above it)? I need it to appear correct both on the screen and
when printed.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



Bob Umlas

typing a complement (i.e. notA) character in Excel
 
Debra -- why should the odd-size font make such a difference? (And it does!)
Bob Umlas

"jheby" wrote in message
...
That works great - thanks a bunch!

"Debra Dalgleish" wrote:

Format the cell with Symbol font, and an odd-numbered font size, e.g. 9
or 11
Hold the Alt key, and on the number keypad, type 0096
Release the Alt key, and type an upper case C
Press Enter, to complete the entry


jheby wrote:
Is there any way to type the math convention of a complement in Excel

(an X
with a line above it)? I need it to appear correct both on the screen

and
when printed.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





Dave Peterson

typing a complement (i.e. notA) character in Excel
 
This worked ok with even numbered font sizes:


Bob Umlas wrote:

Debra -- why should the odd-size font make such a difference? (And it does!)
Bob Umlas

"jheby" wrote in message
...
That works great - thanks a bunch!

"Debra Dalgleish" wrote:

Format the cell with Symbol font, and an odd-numbered font size, e.g. 9
or 11
Hold the Alt key, and on the number keypad, type 0096
Release the Alt key, and type an upper case C
Press Enter, to complete the entry


jheby wrote:
Is there any way to type the math convention of a complement in Excel

(an X
with a line above it)? I need it to appear correct both on the screen

and
when printed.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



--

Dave Peterson

Dave Peterson

typing a complement (i.e. notA) character in Excel
 
Doh..

This worked ok for me with even number font sizes:
=CHAR(96)&"C"

And the rowheight adjusted nice enough to see things

Well, it was nice for some even number font sizes--not all.

Bob Umlas wrote:

Debra -- why should the odd-size font make such a difference? (And it does!)
Bob Umlas

"jheby" wrote in message
...
That works great - thanks a bunch!

"Debra Dalgleish" wrote:

Format the cell with Symbol font, and an odd-numbered font size, e.g. 9
or 11
Hold the Alt key, and on the number keypad, type 0096
Release the Alt key, and type an upper case C
Press Enter, to complete the entry


jheby wrote:
Is there any way to type the math convention of a complement in Excel

(an X
with a line above it)? I need it to appear correct both on the screen

and
when printed.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



--

Dave Peterson

Debra Dalgleish

typing a complement (i.e. notA) character in Excel
 
I don't know why it makes a difference. On my monitor, some sizes look
ragged, and those, usually the even-numbered ones, have a misplaced bar.
They all look okay when printed on my printer though.

The SymbolPS font looks better on-screen, in all font sizes, and its bar
is a bit longer. However, I don't know if that's a standard font.

Bob Umlas wrote:
Debra -- why should the odd-size font make such a difference? (And it does!)
Bob Umlas

"jheby" wrote in message
...

That works great - thanks a bunch!

"Debra Dalgleish" wrote:


Format the cell with Symbol font, and an odd-numbered font size, e.g. 9
or 11
Hold the Alt key, and on the number keypad, type 0096
Release the Alt key, and type an upper case C
Press Enter, to complete the entry


jheby wrote:

Is there any way to type the math convention of a complement in Excel

(an X

with a line above it)? I need it to appear correct both on the screen

and

when printed.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html







--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 04:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com