Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a number to a letter of the alphabet to get a letter [email protected] Excel Worksheet Functions 5 May 21st 07 04:25 PM
How do i set up a list that sorts as Number/letter/number in orde xorex Excel Discussion (Misc queries) 3 September 8th 06 12:59 AM
change headers from letter to number/number to letter lazybee Excel Worksheet Functions 1 July 29th 05 11:08 PM
column header changed from letter to number, how return to letter Ron Excel Discussion (Misc queries) 2 May 9th 05 08:34 PM
Auto number w/ different letter-number combos in same column Colleen B Excel Worksheet Functions 2 February 23rd 05 02:41 PM


All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"