+ Reply to Thread
Results 1 to 8 of 8

how to remove "0" in the blank rows

  1. #1
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    136

    how to remove "0" in the blank rows

    hello,
    i've got a problem.do you know how to remove the number"0" in the blank rows?
    download the file at:http://www.scribd.com/doc/105789200

  2. #2
    Registered User
    Join Date
    08-30-2012
    Location
    NZ
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: how to remove "0" in the blank rows

    Could be your format. Can you attach your spreadsheet? Or an example

  3. #3
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: how to remove "0" in the blank rows

    Hi Pejoi,

    That link is asking for login details.. can you download that and upload here .. thanks.


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  4. #4
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    136

    Re: how to remove "0" in the blank rows


  5. #5
    Registered User
    Join Date
    06-12-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    86

    Re: how to remove "0" in the blank rows

    Kindly Attach the file

  6. #6
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: how to remove "0" in the blank rows

    Use..

    =IF(ISBLANK(your_formula),"",your_formula)
    or
    =IF(your_formula="","",your_formula)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  7. #7
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    136

    Re: how to remove "0" in the blank rows

    HTML Code: 

  8. #8
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: how to remove "0" in the blank rows

    Hi pejoi,

    Has this code helped you ?

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1