Monthly Archives: December 2016

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”)

Posted in Others | Leave a comment