![]() |
Number zero and the Letter O formatting
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 |
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 |
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 |
All times are GMT +1. The time now is 04:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com