Skip to Content
Former Member
Mar 14, 2011 at 04:49 PM

WAD invalid format when manually delete a value in a cell



In the WAD my input cells in the planning layout is blank. When I input a value, then I highlight it and delete it, I get an error message saying it has an invalid format. You can only delete the cell value by inputing a zero.

In Bex excel if you delete a value it automatically puts it to zero. In WAD if you delete a value it doesn't automatically put it to zero, and gives the "Invalid Format" error.

Is there a way in WAD in which the user can just delete the value manually and the system automatically knows its a zero value like in excel?