Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
How do i set up a list that sorts as Number/letter/number in orde | Excel Discussion (Misc queries) | |||
change headers from letter to number/number to letter | Excel Worksheet Functions | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Auto number w/ different letter-number combos in same column | Excel Worksheet Functions |