I'm using Excel 2007. I've changed the date format to dd/mm/yyyy with no problems.
However, as soon as I begin to edit a date, it changes to the format to mm/dd/yyyy, in both the cell being edited and formula bar. After I have made my changes and leave the cell, it reverts back to dd/mm/yyyy.
As you can imagine, this gets very confusing.
This has only started since I upgraded to Windows 10. I didn't have this issue using Windows 7.
I thought that's how it is supposed to work. what you see when editing should be reflecting the system date format as defined for the windows. Formatting is just to show visually how it looks to the users