Recognise zeroes and blanks as different data inputs when using number formatting

Can we add a number formatting option (text fomatting causes issues for our users) with a default for the cell of blank (if blank then the cell is ignored) and then if a zero is input it is treated as a number.

For example - the default calculation for sales volume generates 50 for January 2018, there is an "override" line to allow the user to adjust this. If the user doesn't input into it then the 50 is taken as the answer, if 40 then 40 is taken, if 0 then the 0 is taken.

Currently the only way we can do this is by using an additional boolean line item which is ticked if the user wants to use a zero override, but this clutters up the model so we would like to eliminate this.

46 votes

Not Planned · Last Updated


  • Status changed to: Not Planned
  • I end putting in 0.000000000000000000000000000000000000000000000000000000000000000001 or similar to get around this quandry!

  • Ha! Yes we do that as well but it's not ideal is it! Especially as we have users across our business who are not a fan of workarounds!


  • Status changed to: Not Planned
  • It would be very useful in order to override by 0 ! Currently we add a boolean line item that users check if they want to override by 0, but it takes screen space and can't be incuded in line item subsets.

  • I have a client that needs to be able to override by 0. Their users are sales people and don't understand having to put in .01 instead of 0. Why aren't we able to do this??


  • Status changed to: Not Planned

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!