hi. whenever i try to enter a date in a particular cell for eg.
14/11/07 (i.e. 14 November, 2007) the date that is displayed in the
cell is 7-Nov-14 (i.e. 7 November, 2014) !. i have tried all possible
options in the format cells section and even to the extent of changing
the system regional date settings. Please help!