Number zero and the Letter O formatting

  • Thread starter Thread starter johnsevenoaks999
  • Start date Start date
J

johnsevenoaks999

Hi all,

Is there a way to show clearly if it's a number zero or a letter O. I'm
trying to check quite a few hundred product codes (for EDI mapping) and
was wondering if there was a way to have zero appear with a line
through it (like I can for printing)or something similiar.

My workaround for the moment is to use a find a replace with "%" so I
can see it clearly but I'm thinking ahead to when other people are
entering codes.

Thanks for any help.

John G
 
John,

Change the font to Terminal, it shows zeros with a slash through them.
If your machine is setup to show only TrueType fonts, you will have to
type the font name manually, because it won't show up in the list of fonts.

Best regards,
Ture Magnusson
Karlstad, Sweden
 

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

Conditional Formatting and VBA 4
Zero Upload Speed 6
Convert Letters to Numbers? 8
Numbers and Letters 7
Adding a leading zero "0" to a number in a cell 2
Using column with numbers and leading zeros 2
Cells drop leading zeros from numbers 7
Split cell contents and sum numbers 3

Back
Top