Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    format blank cell to display zero (Excell 2000 9.0.3821 SR-1)

    Is it possible to format a cell that is blank to display zero?

    I have a series of spreadsheets with linked cell that produce numerous graphs. Each month I get a text file from SAS and cut and paste the current data into my spreadsheets. Whenever there is a blank space, the cut and paste leaves the space blank. Where that cell is used in a calculation, the result is #VALUE! and if that cell is part of the source value for a graph, it shows as zero, even though several of the other cells in the formula had values in them. If I manually key zero's into the blank cells, then all of the formulas work and the graphs are fine.

    Thanks for any suggestions.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: format blank cell to display zero (Excell 2000 9.0.3821 SR-1)

    The problem you have is caused by the fact that those cells are not really blank. Excel thinks they contain text. You might select the area of interest (skip any headings you need to keep) then hit F5 (goto), special, constants, check only the text entry and OK. Now simply hit the del key to clear those cells.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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