View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ture Magnusson[_2_] Ture Magnusson[_2_] is offline
external usenet poster
 
Posts: 3
Default Number zero and the Letter O formatting

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

wrote in message
oups.com...
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