View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T Kirtley T Kirtley is offline
external usenet poster
 
Posts: 82
Default 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