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

J

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

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

Unwanted line across top of pages; how to delete? 0
New computer, how do i move outlook 365 ENTIRELY? 0
Problem with MS Word paragraph and character styles: format getting messed up 2
Removind diagonal lines created on sheet 6
pivot table - shows zero when should not be 1
How do I stop Excel from dropping leading zeros? 2
Chart - Custom Stacked Bar with Line 0
how do I add a zero in front of a bunch of 4 digit numbers? 7

Top