A sample of the cells contain something like this:
=SUMIF(SUMM!$B$369:$B$542,$A184,SUMM!$F$369:$F$542)=SUMIF($A$2:$A$202,A184,$D$2:$D$202)
The formatting for these cells are set to Custom and looks like this:
_(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)
When I open the file in Excel 2007, the values of those cells come up as TRUE or FALSE, and get printed as such.
My question is why did it print it as 1's and 0's before? I believe these files were printed from another machine but I'm not 100% certain. Essentially I'm trying to find the cause of the problem so that I could fix it and avoid this from happening in the future.
Bookmarks