In column B the format is Custom and dd/mm/yyyy. The cell appears in that format which is great - for example today it shows as 24/10/2013. However, when I click the cell and look at the formula bar it displays as mm/dd/yyyy. How can I fix this so that it shows as dd/mm/yyyy in the formula bar as well?
Bookmarks