Thread: hide zeros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ralpha ralpha is offline
external usenet poster
 
Posts: 1
Default hide zeros

how do I hide zero results when I'm using this formula: =LEFT(AL8,1)

I have tried conditional formatting and custom numbering but ca't get it to
work.