Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make zeros show up with a diagonal line across them?
I have some codes that go to customers that contain both zeros and the letter
O. They look very similar and to avoid confusion, I have been requested to make the zeros show up as zeros with a diagonal line across them. I am using Excel 2003 SP2. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make zeros show up with a diagonal line across them?
You'd have to use a font which displays 0s in such a way.
I don't know which font does that but I'm sure there is one out there. Just experiment with different fonts. Or perhaps google something like "calculator display font" "jhe2006" wrote: I have some codes that go to customers that contain both zeros and the letter O. They look very similar and to avoid confusion, I have been requested to make the zeros show up as zeros with a diagonal line across them. I am using Excel 2003 SP2. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make zeros show up with a diagonal line across them?
You need to have a slashed zero font installed.
Check out this 'net search result for downloads. HamFonts has an Arial slashed font and are free. http://snipurl.com/v35h Gord Dibben MS Excel MVP On Thu, 17 Aug 2006 07:04:01 -0700, jhe2006 wrote: I have some codes that go to customers that contain both zeros and the letter O. They look very similar and to avoid confusion, I have been requested to make the zeros show up as zeros with a diagonal line across them. I am using Excel 2003 SP2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i make a chart to show range and median ? | Charts and Charting in Excel | |||
how to show date on the x axis of a line chart? | Charts and Charting in Excel | |||
How do I make a section of a chart line dotted? | Charts and Charting in Excel | |||
How do I make a section of a chart line dotted? | Charts and Charting in Excel | |||
how do I make make my hyperlinks show the email address they are . | Excel Discussion (Misc queries) |