Home » Category » Microsoft Excel

Microsoft Excel: Zero with a slash

205| Thu, 22 May 2008 21:24:00 GMT| anonymous| Comments (7)
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).

Keywords & Tags: zero, slash, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495000/
 
«« Prev - Next »» 7 helpful answers below.
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).
>

ken | Thu, 22 May 2008 21:25:00 GMT |

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, ...

abcd | Thu, 22 May 2008 21:26:00 GMT |

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).
>

max | Thu, 22 May 2008 21:27:00 GMT |

You could key ALT + 0216; hence Ø.

dna | Thu, 22 May 2008 21:28:00 GMT |

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

dave | Thu, 22 May 2008 21:29:00 GMT |

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
>

stan | Thu, 22 May 2008 21:30:00 GMT |

That is excellent, thank you.
Stan

"DNA" wrote:

> You could key ALT + 0216; hence Ã?.
>

stan | Thu, 22 May 2008 21:31:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories