Formatting 0 (Zero) in Excel 5

[bdjb]

Hello All,
I looked at every setting (I think), is there a way to format the display of 0 (zero) in Excel 97 to show as the old computer zero (with the slash through it, so you know it isn't a capital o)?

Office 97
Windows XP

Thanks,
Bob

 

[Dreamboat]

Bob:

Not to my knowledge, which is fairly decent, no. Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[bdjb]

Hi Anne,
Thanks for replying, it would be easier to glance at a cell and see by format if it was a O or a 0.

Oh well, we'll see if anyone has a trick op their sleeve..

Thanks again,
Bob

 

[combo]

Look at all fonts installed - some can have 0 with slash (on my machine - Terminal, unfortunately not TT font). Another option - font editors.

combo

 

[Zathras]

Try a different font,
e.g., FixedSys, or Terminal, or VAGRound

 

[mscallisto]

It ain't pretty but maybe a strikethrough. see example of what it looks like.


Enter a zero 0 in a cell
rightmouse click choose format cell and pick strikethrough.

It isn't on a slant but it isn't the letter O either.

 

[bdjb]

Thanks Combo and Zathras!
I was trying the hard way, figuring there HAD to be a system setting, I never even though about changing the font. Terminal gave me just what I was looking for.

Thanks again,
Bob

 

[mscallisto]

There is also an extended ascii character 237 thats very close. Set cell to char(237).


see the character at:

http://www.cdrummond.qc.ca/cegep/informat/Professeurs/Alain/files/ascii.htm

 

[DaleWatson123321]

Bob,

Here's an option that just might be suitable... IF you ONLY intend to use this when the value in a cell (from a formula or value) is ZERO.

Steps:

1) Use Format - Cells

2) Under "Number", click on "Accounting", and then on "Custom"

3) Under "Type" (on the right), edit the Accounting format (to make it a Custom format)...

Change it FROM this:
_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)

TO this:
_(* #,##0_);_(* (#,##0);_(* "Ø"_);_(@_)

Note: To get the Ø character, hold down the <Alt> key and enter on the number pad the number: 0216

With this number format, it will ONLY show the Ø when the formula or cell value is zero.

If this is suitable, but you want to change the number of decimals, you can do so. However, ONLY place the Ø character in the SAME section of the format formula -.e.g.

_(* #,##0.00_);_(* (#,##0.00);_(* &quot;Ø.ØØ&quot;;_(@_)

will give you 2 decimal places.

Finally, because the Ø character if really the same size as the letter &quot;O&quot;, it will not align properly with numbers.

Therefore, an option to consider, is to use the following format, which will align properly. It simply places a hyphen on both sides - e.g.: -0-

The format formula (for no decimal places) would be:
_(* #,##0_);_(* (#,##0);_(* &quot;-0-&quot;_);_(@_)

I hope this at least gives you an option.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[bdjb]

Thanks Dale,
That's great option as well.

Bob

 

[DaleWatson123321]

WELL... I can see there has been PLENTY of activity since I began with my suggestion for the SAME font.

Nice work guys. ;-) I too should have recommended using a DIFFERENT font.

Another STAR from me.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca