Question: how to change date format to dd/mm/yyyy in excel 2007?
Answer: Manual change in Excel In Excel, you can manually change the format of a particular cell by right-clicking on any cell >> select Format Cells >> Date >> change the Locale (location) to the desired format. This allows you to format the date however you'd like.