Hi, this is a follow on question about zero values. Thanks to JohnSUN I have managed to get my spreadsheet to look how I want it to, with most (…but not all…) zero values hidden. However, when I print, print-preview or export as pdf, ALL the zeros vanish. Is there any setting that I can use to make only those Zeros that show to print while leaving the others blank ?
Sorted ! Used Format > Page > then made sure Print Zero Values was ticked. In conjunction with the specific number formats used on the sheet, this now only prints those Zeros I wanted printing !
ver. 7.2.6.2
\ Format \ Page style… \ Sheet tab \ Print \ Check box marked Zero Values