If I am not mistaken, excel currently considers a blank cell the same as a cell with a zero value.
If I am not mistaken, excel currently considers a blank cell the same as a cell with a zero value. This is fundamentally incorrect as zero is a legitimate number. For example Billy may have 3 pencils and Bobby has no pencils. So, Bobby has '0' pencils- not 'blank' pencils. Excel excepts 0 as a first entry- but when linked to a cell it eithers displays all blanks and zeros the same way. This is a problem when a worksheet is set up for 20 children where a report is preset up with links to the number of pencils each child has. Basically, there are three choices: 1) numbers other then zero, 2) zero (the child has no pencils), and 3) a blank (the information has not been gathered). The problem arises as the linked report shows a zero entry and a blank exactly the same way- so the user doesn't know if a child has no pencils or the information has not yet been gathered.
My spreadsheet is much more complicated, but I am not finding a work-around....THANKS!