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

kenrussellyourhat@optushome.com.au
Remove yourhat to reply by e-mail
..

"Stan" <Stan@discussions.microsoft.com> wrote in message
news:EC99F825-53C9-4B53-BF17-36C8303E26F3@microsoft.com...
> 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 <at>yahoo<dot>com
----
"Stan" <Stan@discussions.microsoft.com> wrote in message
news:EC99F825-53C9-4B53-BF17-36C8303E26F3@microsoft.com...
> 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
>