R rdownes New Member Mar 5, 2012 #1 I am building a spreadsheet but i have zeros and div0 showing up in all of my cells formatted for results. I want to keep them blank until there is actually a result to go into them. thanks
I am building a spreadsheet but i have zeros and div0 showing up in all of my cells formatted for results. I want to keep them blank until there is actually a result to go into them. thanks
Debraj Excel Ninja Mar 5, 2012 #2 @rdownes Welcome to the Jungle.. File > Excel Option > Advanced > Uncheck 'Show a Zero in Cell that have Zero value' (Alt + Z)
@rdownes Welcome to the Jungle.. File > Excel Option > Advanced > Uncheck 'Show a Zero in Cell that have Zero value' (Alt + Z)
