How do I make zeros show up with a diagonal line across them?

[jhe2006]

I have some codes that go to customers that contain both zeros and the letter
O. They look very similar and to avoid confusion, I have been requested to
make the zeros show up as zeros with a diagonal line across them.

I am using Excel 2003 SP2.

[Dave F]

You'd have to use a font which displays 0s in such a way.

I don't know which font does that but I'm sure there is one out there. Just
experiment with different fonts.

Or perhaps google something like "calculator display font"

"jhe2006" wrote:

> I have some codes that go to customers that contain both zeros and the letter
> O. They look very similar and to avoid confusion, I have been requested to
> make the zeros show up as zeros with a diagonal line across them.
>
> I am using Excel 2003 SP2.

[Gord Dibben]

You need to have a slashed zero font installed.

Check out this 'net search result for downloads.

HamFonts has an Arial slashed font and are free.

http://snipurl.com/v35h


Gord Dibben MS Excel MVP


On Thu, 17 Aug 2006 07:04:01 -0700, jhe2006 <jhe2006@discussions.microsoft.com>
wrote:

>I have some codes that go to customers that contain both zeros and the letter
>O. They look very similar and to avoid confusion, I have been requested to
>make the zeros show up as zeros with a diagonal line across them.
>
>I am using Excel 2003 SP2.