Thread: how do i remove zeroes values from exel sheet
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how do i remove zeroes values from exel sheet
How are the zero values generated?

If by formula you could trap for them like...........

=IF(A1*B1=0,"",A1*B1)


Gord Dibben MS Excel MVP

On Mon, 4 Jun 2007 15:49:00 -0700, Ana wrote:

Hi I do not want zeroes on my sheet how do I can remove it? I have Exel 2007
Thank you,

Reply With QuoteReply With Quote