Validating date format

We have used here a text box for date input as some times users also demand for it.

The only problem is, Excel (2013) treats (new) dates as being in US format as soon as I apply validation. Syntax Highlighting Whenever you save the relevance equation, it will be evaluated and syntax-highlighted.Any errors will be color coded so that you can quickly detect and fix them.Excel will then still recognize the date entered by the user in his format.And if you insist, you can still output the date in your country specific way (by providing the right local in the format number dialog).

Leave a Reply