First, select the cells that need the special date format. Right-click and choose Format Cells. Now click the Number tab and from the Category list, click Custom. In the Type text box, type mm/dd/yyyy. Click OK. Now you should see all four digits of the year in those cells.
Our vision is to constantly delight our clients by closely working with them to draw up new business strategies to scale up their business, cut costs, improve profitability and have good control.