G Guest Aug 9, 2005 #1 Is there a way to show zero balances in some selected cells and at the same time not show zero balances in the other cells? Ed
Is there a way to show zero balances in some selected cells and at the same time not show zero balances in the other cells? Ed
B Biff Aug 9, 2005 #2 Hi! Use this custom format to "hide" the zeros you don't want displayed: 0;-0;;@ Just be aware that the zero is still there, it just can't be seen. Biff
Hi! Use this custom format to "hide" the zeros you don't want displayed: 0;-0;;@ Just be aware that the zero is still there, it just can't be seen. Biff
P Peo Sjoblom Aug 9, 2005 #3 What do you want in those cells not showing zero, blank? If so you can use custom formatting for those that you don't want to show $#,##0.00;-$#,##0.00; using US centric currency and no zeros shown -- Regards, Peo Sjoblom (No private emails please)
What do you want in those cells not showing zero, blank? If so you can use custom formatting for those that you don't want to show $#,##0.00;-$#,##0.00; using US centric currency and no zeros shown -- Regards, Peo Sjoblom (No private emails please)
