Issues with Leading Zeros in Filters

When I run my reports, all of the amounts are converted to Values. That wouldn't be a problem, except I've built most of my reports to reference specific cells for segments of our general ledger account and some of those segments have leading zeros. IE, we have a fund "001", Cost Center "000", Program "0001", etc. Every time I want to refresh or go back into Design mode, I have to redo 90% of my referenced cells.

Cell A1 has "Auto+Hide" in it, not "Auto+Hide+Value".

My hunch is that some box somewhere got checked when it shouldn't have. Any help would be greatly appreciated.

James Wilkins
Controller, Jewish Community Centers of Chicago


Please sign in to leave a comment.