change zero to slashed zero??

[Brad Schmitz]

Can the look of a 'zero' be changed to look like a 'slashed zero'?
I'm trying to track our computer system info. and 'MAC' addresses use
letters and numbers.
It would make it earier for quick glance identification.
Brad

 

[David McRitchie]

Hi Brad,
I think you would want to choose or find a font that has that look,
take a look through CharMap using the arrow key.

WST_Engl appears to meet your requirement, of course,
that would be dependent whether you have that font or not...
Lettering IRON 014 appears distinguishable.

I reference the CharMap from my Excel toolbar menu
and include the icon in the menu.
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm
http://www.mvps.org/dmcritchie/excel/toolbars.htm

 

[Brad Schmitz]

Thanks David,
The WST_Engl is exactly what I was looking for. I know there's a difference
between the letter O and the number zero 0 but when they're not next to each
other or they're used alone and you need to know which it is, it can get
confusing.
Again, Thank You very much.
Brad

Hi Brad,
I think you would want to choose or find a font that has that look,
take a look through CharMap using the arrow key.

WST_Engl appears to meet your requirement, of course,
that would be dependent whether you have that font or not...
Lettering IRON 014 appears distinguishable.

I reference the CharMap from my Excel toolbar menu
and include the icon in the menu.
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm
http://www.mvps.org/dmcritchie/excel/toolbars.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Can the look of a 'zero' be changed to look like a 'slashed zero'?
I'm trying to track our computer system info. and 'MAC' addresses use
letters and numbers. > It would make it earier for quick glance

identification.

 

[Gord Dibben]

Brad

I emailed you a small slashed0.ttf font file.

Gord Dibben Excel MVP

Thanks David,
The WST_Engl is exactly what I was looking for. I know there's a difference
between the letter O and the number zero 0 but when they're not next to each
other or they're used alone and you need to know which it is, it can get
confusing.
Again, Thank You very much.
Brad

Hi Brad,
I think you would want to choose or find a font that has that look,
take a look through CharMap using the arrow key.

WST_Engl appears to meet your requirement, of course,
that would be dependent whether you have that font or not...
Lettering IRON 014 appears distinguishable.

I reference the CharMap from my Excel toolbar menu
and include the icon in the menu.
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm
http://www.mvps.org/dmcritchie/excel/toolbars.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Can the look of a 'zero' be changed to look like a 'slashed zero'?
I'm trying to track our computer system info. and 'MAC' addresses use
letters and numbers. > It would make it earier for quick glance

identification.

 

[macropod]

Hi Brad,

If you only want cells with zero values to display a Ø, you can do it with a
custom number format such as #,##0;-#,##0;Ø, where the Ø is produced by the
Alt-0216 key combination. This won't affect any calculations, since only the
display formatting has been changed - the underlying 0 is still there.

Cheers

Thanks David,
The WST_Engl is exactly what I was looking for. I know there's a difference
between the letter O and the number zero 0 but when they're not next to each
other or they're used alone and you need to know which it is, it can get
confusing.
Again, Thank You very much.
Brad

Hi Brad,
I think you would want to choose or find a font that has that look,
take a look through CharMap using the arrow key.

WST_Engl appears to meet your requirement, of course,
that would be dependent whether you have that font or not...
Lettering IRON 014 appears distinguishable.

I reference the CharMap from my Excel toolbar menu
and include the icon in the menu.
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm
http://www.mvps.org/dmcritchie/excel/toolbars.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Can the look of a 'zero' be changed to look like a 'slashed zero'?
I'm trying to track our computer system info. and 'MAC' addresses use
letters and numbers. > It would make it earier for quick glance

identification.