Follow these steps: Select the cells you want to format. Press CTRL+1. In the Format Cells box, click the Number tab. In the Category list, click Date. Under Type, pick a date format. … If

NumberFormat property, I explain the different date format codes you can use and present 25 date formatting examples using VBA. Step #1: Go To The Number Tab Of The Format Cells Dialog Box. Step #2:

You may also be able to use the . NumberFormat property of the range. For example, if your date you want formatted as dd/mm/yyyy is in cell A1 you could use Range(« A1 »). NumberFormat = « dd/mm/yyyy »