+ Reply to Thread
Results 1 to 3 of 3

How remove zero values representing blank cells from original table connected to new table

  1. #1
    Registered User
    Join Date
    07-28-2013
    Location
    earth
    MS-Off Ver
    Excel 2010
    Posts
    19

    How remove zero values representing blank cells from original table connected to new table

    Hi

    -I'm using non english Ms Excel 2010

    I have made one sheet with original table like this:
    Please Login or Register  to view this content.
    in other sheet I need copy of that table, so I connected (tied) (I don't know correct english word sorry) original with copy.
    I need just data, formatting doesn't matter. Like this:
    Please Login or Register  to view this content.
    (In my language 'Hárok' means Sheet btw)


    1, I know about excel options > advanced card > Show a zero in cells that have zero value.
    2, I know about custom formatting exact cells with text: 0;-0;;@
    3, I know about Pivot table zero setting, but I haven't pivot tables and never will use.
    so those ones, are not solutions for me.
    Why ?
    Because I need to keep blank cells blank in 'copy' sheet same as in original, and cells with value zero, same with value zero. But now excel made all zeros out of purpose by changing untouched cells to zeros and also zero value cells to zero. I need make him distinguish between those two types of zero cells, or just simply not write zeros into blank cells.

    I have found this old article:
    Please Login or Register  to view this content.
    - someone wrote this command to write into cell:
    Please Login or Register  to view this content.
    - I was trying to rewrite it with any combination because I'm using excel 2010, but excel don't want accept my formula. Something is wrong. (Yes I changed word Sheet for word in my language)
    Please help me how may I set it well

    Thanks a lot

  2. #2
    Forum Contributor
    Join Date
    09-30-2013
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2007
    Posts
    229

    Re: How remove zero values representing blank cells from original table connected to new t

    You may need to post your spreadsheet so we can see it.
    I tried you're examples it worked as you wanted. There may be some other problem
    If this helped, please click (*) Add Reputation

  3. #3
    Registered User
    Join Date
    07-28-2013
    Location
    earth
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: How remove zero values representing blank cells from original table connected to new t

    you mean this worked ? =IF(ISBLANK(Sheet1!A1),"",Sheet1!A1)
    in native english excel ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 3D Bar Chart Representing 3 - Connected Datasets
    By Freedaja in forum Excel General
    Replies: 0
    Last Post: 03-19-2012, 11:32 AM
  2. Creating new table from selective data in original table
    By rasmussk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2009, 09:46 AM
  3. pivot table counting blank cells in data table
    By nicko54 in forum Excel General
    Replies: 4
    Last Post: 09-23-2008, 11:26 AM
  4. Replies: 2
    Last Post: 09-23-2008, 11:01 AM
  5. How do I remove the (blank) from an excel pivot table?
    By MarkfromAZ in forum Excel General
    Replies: 2
    Last Post: 10-14-2005, 09:05 AM

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