View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default Number zero and the Letter O formatting

Change the font to one that has a line thru the 0.. such as WST_Engl.
Mike F
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