Prev: Date formatting
Next: Dates converted into text
From: rjagathe on 4 Mar 2010 11:20
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?
From: Simon Lloyd on 4 Mar 2010 16:28

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 TOOLS>OPTIONS>SPELLING check you are using the correct dictionary.


r
j
a
g
a
t
h
e
;
6
6
1
1
2
4

W
r
o
t
e
:


>
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/showthread.php?t=184614

[url="http://www.thecodecage.com/forumz/"]Excel Live Chat[/url]

 | 
Pages: 1
Prev: Date formatting
Next: Dates converted into text