1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Values? (Excell)

Discussion in 'Other PC Software' started by Spete, 2003/12/10.

Thread Status:
Not open for further replies.
  1. 2003/12/10
    Spete

    Spete Inactive Thread Starter

    Joined:
    2002/01/27
    Messages:
    20
    Likes Received:
    0
    Values?

    Below problem applies to Excel 2000.

    When I fill in a 0 (zero) in a cell where there's a formula already entered, the value of the cell changes to 'value#' When I open a new sheet and enter a 0 in a cell, it disappears. Cell formats appear to be ok. Just to be on the safe side: Office has been reinstalled. Nothing apparant in Regional options. Office language is set to UK.

    Any ideas?:confused:
     
    Spete,
    #1
  2. 2003/12/10
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    Go to Tools > Options > View tab - Window options and make sure 'Zero Values' are ticked.
    This suggests to me an error in the formula in the cell - you may need to use an 'IF statement, i.e. =IF(D1117>0,H1116+D1117,IF(F1117>=0,H1116-F1117,0)) - copied from one of my spreadsheets.

    HTH
     
    PeteC,
    #2


  3. to hide this advert.

Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...