At 23:11 26/08/2012 +0200, Ennio Sr wrote:
I would rather prefer that warning be fired when an inappropriate
value is typed in a cell more than in the cell containing the
formula: if a cell is formatted to contain a date, it should not be
possible to put a space in it ...
That's fairly easy:
o Select the relevant range of cells.
o Go to Data | Validity... .
o On the Criteria tab, for Allow select Date.
o On the Error Alert tab, tick "Show error message when invalid
values are entered" and for Action select Stop.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
