Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format 0 so it has a line though it
I am looking for a way that when I type in the number 0 is shows a slash
through it so as to differ it from the letter 0 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
format 0 so it has a line though it
You can use the 'Accounting' number format which uses a dash for zeros, or
you could build a custom number format to do this. Try the following as a custom number format: General;General;Ø;@ If you want to modify this format you can enter the Ø symbol with the Alt^0216 key sequence, or you can just copy the charactor in this post. HTH, TK "MDjenkins" wrote: I am looking for a way that when I type in the number 0 is shows a slash through it so as to differ it from the letter 0 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
format 0 so it has a line though it
Find a font that supports slashed 0's.
Google will help you find lots--some will be free, others not. I found this a long time ago: http://www.qsl.net/wa6axe/fonts.html Remember that if you share the file, then that recipient will have to have that same font installed to see the slash. MDjenkins wrote: I am looking for a way that when I type in the number 0 is shows a slash through it so as to differ it from the letter 0 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
format 0 so it has a line though it
where are fonts stored?
"Dave Peterson" wrote: Find a font that supports slashed 0's. Google will help you find lots--some will be free, others not. I found this a long time ago: http://www.qsl.net/wa6axe/fonts.html Remember that if you share the file, then that recipient will have to have that same font installed to see the slash. MDjenkins wrote: I am looking for a way that when I type in the number 0 is shows a slash through it so as to differ it from the letter 0 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
format 0 so it has a line though it
where are fonts stored?
In Windows XP built-in "Help" there's a page: "Add a new font to your computer" |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
format 0 so it has a line though it
I think it depends on your version of windows.
But with WindowsXP (home), my fonts are stored in: C:\windows\font But there's an option when you install a font asking if you want to move it to this location. I answer yes to keep them all together--but it's a user option. Sloth wrote: where are fonts stored? "Dave Peterson" wrote: Find a font that supports slashed 0's. Google will help you find lots--some will be free, others not. I found this a long time ago: http://www.qsl.net/wa6axe/fonts.html Remember that if you share the file, then that recipient will have to have that same font installed to see the slash. MDjenkins wrote: I am looking for a way that when I type in the number 0 is shows a slash through it so as to differ it from the letter 0 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel chart draws line outside Y axis | Charts and Charting in Excel | |||
How do I use a formula to create a new line of text in a cell? | Excel Worksheet Functions | |||
Custom Format Cell | Excel Discussion (Misc queries) | |||
format data series line width default | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel |