In my Excel files,when I click a cell that contain "date" it changes
into dd/mm/yyyy format.But,in the formula bar,the same date is
displayed in mm/dd/yyyy format.Why it is so?
I want all the dates in dd/mm/yyyy format only.Will there be any
problem while sorting if the date column contais dates of different
formats i.e. dd/mm/yyyy and mm/dd/yyyy as well?