Excel – Producing consistent data – 5 Validating
Validating is a way of preventing the incorrect entry of data. It can also produce warning screens and error messages to give information to users entering the data. Example 1 You wish to have a column in a worksheet that displays the date in the format of 28 June 2018. You can use the formatting…