Is there any font or way in Excel to put a strike mark through a zero?

[GoingUp]

Making up a list of a bunch of computers here at work and a lot of names contain either 0 or O. I want to make a strike mark through the zero like you normally see on older computer fonts. Anyway to do this, or any font I can use to do this? Thanks!

 

[DurocShark]

I would have sworn there was a setting for that. But I can't find it and all my Excel books are at work.

 

[Cristatus]

Use the Fixedsys font. Problem fixed. (No pun intended)

 

[PlatinumGold]

i don't know the answer to your question, but try opening a csv file of addresses with all NJ zipcodes in excel.

fvckiing thing drops all the zeros in the zip code line. you have to reformat the column to text not number, but by then it's already dropped all the zeros.

 

[DurocShark]

Originally posted by: PlatinumGold
i don't know the answer to your question, but try opening a csv file of addresses with all NJ zipcodes in excel.

fvckiing thing drops all the zeros in the zip code line. you have to reformat the column to text not number, but by then it's already dropped all the zeros.

So even Excel knows Jersey sucks?

:laugh:

 

[b0mbrman]

Originally posted by: PlatinumGold
i don't know the answer to your question, but try opening a csv file of addresses with all NJ zipcodes in excel.

fvckiing thing drops all the zeros in the zip code line. you have to reformat the column to text not number, but by then it's already dropped all the zeros.

[Edit] Wait a second...