Functions Return 0

  • Thread starter Thread starter Jonathan Grotegut
  • Start date Start date
J

Jonathan Grotegut

All functions are ruturning zero when there is no data.
Is there a way to show them as blank instead of having the
0? TIA
 
Tools|Options|View, unchecked zero values.
All zeroes will be shown as blanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort column beginning with blank? 1
LOOKUP question 5
Displaying zeros in cells 2
COUNT BLANK AND ZERO AS THE SAME THING 6
Counting Zeros in a row until encounter first non-zero value 9
Calculation / Format Error 1
=IF(ISERROR(GB18-FC18),"",(GB18-FC18)) returning zero instead of b 2
TRANSPOSE results in zero values for blank cells 2

Back
Top