Zero with a slash
 

Can I have zero format with a slash through it? If I mix numbers (digits)
with letters in a cell I want to be able to distinguish zeros from Os with a
slash. Example: ABCD000438NOPQ (zeros and Os in same cell).

Excel already distinguishes between 0 and O as you can see here. Zero is
elliptical and O is a circle.

--
Ken Russell


Remove yourhat to reply by e-mail
..

"Stan" wrote in message
...
Can I have zero format with a slash through it? If I mix numbers (digits)
with letters in a cell I want to be able to distinguish zeros from Os with
a
slash. Example: ABCD000438NOPQ (zeros and Os in same cell).

it's a font choice:

some fonts are bad for your purpose, just try many

the one you asked is 8514oem


but a lot of others make the digit 0 and the letter O easy to
distinguish: Terminal, Fixed Size, ...

Perhaps you might want to try these 2 responses by Dave Peterson & Peo as
well: http://tinyurl.com/7vbw3

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Stan" wrote in message
...
Can I have zero format with a slash through it? If I mix numbers (digits)
with letters in a cell I want to be able to distinguish zeros from Os with
a
slash. Example: ABCD000438NOPQ (zeros and Os in same cell).

You could key ALT + 0216; hence Ø.

That may look nice, but any arithmetic will fail.

(or comparisons with numbers that contain 0's)

DNA wrote:

You could key ALT + 0216; hence Ø.

--

Dave Peterson

That is excellent, thank you.
Stan

"DNA" wrote:

You could key ALT + 0216; hence Ø.

Dave,
No arithmetic will be performed using that cell. It is a reference number
combining letters and digits. Less confusion if the zero has a slash. Thank
you.
Stan

"Dave Peterson" wrote:

That may look nice, but any arithmetic will fail.

(or comparisons with numbers that contain 0's)

DNA wrote:

You could key ALT + 0216; hence Ø.

--

Dave Peterson