Order of input validation


In the attached screen shot the 6 cells in red all have validation and cannot be empty. This is in a pop up.

However if all cells are empty rather than highlight the top left cell first (from top to bottom) it starts from bottom left (bottom to top). Is there a way of reversing to start with top left cell rather than most bottom left cell?

Another issue is that I want all input cells set to no decimal places. This does not work consistently (for example when opening window for existing data all cells show “.00” if click in any cell and click out the “.00” disappear but they keep showing up). It seems Formatted or Rounded cannot be used to force this . Any thoughts?

I hope that makes sense.


This topic was automatically closed after 70 days. New replies are no longer allowed.