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
|