ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Number zero and the Letter O formatting (https://www.excelbanter.com/excel-programming/325515-number-zero-letter-o-formatting.html)

[email protected]

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


Ture Magnusson[_2_]

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




Mike Fogleman

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