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

G

Guest

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

Guest

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"
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I show zeros? 2
How do I stop Excel from dropping leading zeros? 9
Why do the preceding zeros disappear when I remove dashes? 3
Sorting data with the letter 'E' included 3
How do I get leading zeros in zip codes in a mail merge 1
How to show zeros (0) as "slashed" to eliminate confusion with "O. 3
How do I format cells to show the number 0 as first number in seri 2
Spliting a number with leading zeros 7

Top