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?

You can check the cells format for date format and choose a date format
that has a * in front of it this doesnt change with system settings, you
should also check your computers language setting and check the settings
in TOOLSOPTIONSSPELLING check you are using the correct dictionary.


rjagathe;661124 Wrote:

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?


--
Simon Lloyd

Regards,
Simon Lloyd
'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=184614

Excel Live Chat