I open a client supplied .xlxs file in excel 2013 or 2010 and I have this result (which is correct)
I open the same in 2016 and I get
There are a multitude of ways of repairing this however no way to detect what was affected in simply opening a file.
Rather than go backwards and downgrade to 2013 is there a setting that can ensure that Excel doesn't take it upon itself to alter the clients data? We actually have to print the zeros and all on marketing pieces and emails.