Does anyone know how to tweak Excel 2007 so it stops displaying zeros when they're the result of a calculation? I remember in older versions, you could just head over to Tools / Options / window options and uncheck the box for zero values to hide them, and everything worked perfectly. For some reason, I can't seem to track down that specific setting in this version. Any chance someone could point me in the right direction?
Thanks so much in advance!
Thanks so much in advance!