Validating data in excel

Hi @Karan, thank you for taking the time to reply to my post. I've tried many different formulas I've found, with limited success, this, at least I know works. Chris Let me just add my 2c to your question/answer: Trying to force the user to enter a date in exactly the format you want is usually less effective then using data validation in combination with the formatting of the cell: The data validation will for instance also allow dates entered as - but if you set the format of the cell to 'dd-mm-yy' will convert the input to the format you want - or give an error message if the date entered is not a proper date.Even better, this will also work, if you deploy your worksheet on a system with another date format than yours, say .It is on by default: parameter is used to toggle on and off the ‘Show input message when cell is selected’ option in the Excel data validation dialog. parameter is used to set the error message that is displayed when a cell is entered.When the option is off an input message is not displayed even if it has been set using parameter is used to set the title of the error message that is displayed when the data validation criteria is not met. The default error message is “The value you entered is not valid.

When the option is on the data validation is not applied to blank data in the cell.A user has restricted values that can be entered into the cell.”.A non-default error message can be displayed as follows: parameter is used to toggle on and off the ‘Show error alert after invalid data is entered’ option in the Excel data validation dialog.Excel Online (formerly Excel Web App) extends your Microsoft Excel experience to the web browser, where you can work with workbooks directly on the website where the workbook is stored.All Office 365 customers can view and lightly edit Office files using Office Online.The Excel desktop app allows full use of this, and other advanced features.

858

Leave a Reply