Professor Excel

Comments 1

  1. Dave Biggers

    In the years since you posted this, have you heard of a way to turn off 0’s via the “sheet” setting method, but make that the default for the workbook, or even better, an environmental default for that desktop installation? On damn near every workbook of any complexity that I’ve built, I always seem to trip over unexpected 0’s with cross-sheet references and it’s a pain in the butt. This holds true whether ti’s ODBC based stuff in the office or my golf and baseball tracking apps at home. Please tell me there’s a little registry switch someplace I can check (or uncheck) that will do this. Thanks …

Leave a comment

%d bloggers like this: