Excel – Set Default Date Format

In the Data Validation dialog box, click Settings tab, and then choose Custom from the Allow drop down list, then enter this formula: =AND(ISNUMBER(B2),LEFT(CELL(“format”,B2),1)=”D”)

This entry was posted in Others. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *