View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
ML ML is offline
external usenet poster
 
Posts: 57
Default How to reset incorrect date format after reinstalation of Window X

Hi,

Thank you very much in advance if someone can assist.

I need to reinstall the window XP. After the installation, the contents of
the "Date" column have been change as follows:

18/02/2008
20/02/2008
21/02/2008
21/02/2008
22/02/2008
25/02/2008
26/02/2008
26/02/2008
29/02/2008
3/3/2008
3/3/2008
4/3/2008
4/3/2008
6/3/2008
7/3/2008
7/3/2008
10/3/2008
10/3/2008
11/3/2008
11/3/2008
13/03/2008
13/03/2008
14/03/2008
14/03/2008
14/03/2008
14/03/2008
17/03/2008
18/03/2008
19/03/2008
19/03/2008
25/03/2008
25/03/2008
25/03/2008
26/03/2008
26/03/2008
26/03/2008
28/03/2008
28/03/2008
31/03/2008
31/03/2008
2/4/2008
2/4/2008
7/4/2008
7/4/2008
7/4/2008

Example 2

2/11/2007
2/11/2007
2/11/2007
5/11/2007
5/11/2007
5/11/2007
5/11/2007
6/11/2007
7/11/2007
7/11/2007
9/11/2007
9/11/2007
12/11/2007
14/11/2007
14/11/2007
15/11/2007
16/11/2007
16/11/2007
19/11/2007
19/11/2007
19/11/2007
20/11/2007
21/11/2007
21/11/2007
21/11/2007
21/11/2007
21/11/2007
22/11/2007
23/11/2007
23/11/2007
26/11/2007
26/11/2007
26/11/2007
26/11/2007
27/11/2007
27/11/2007
27/11/2007
29/11/2007
30/11/2007
3/12/2007
3/12/2007
3/12/2007
3/12/2007
4/12/2007
4/12/2007
4/12/2007

When I move cursor to the date on the left hand side and then click
"format", then "cell", the "general" under "category" was highlighted.

When I move cursor to the date on the right hand side, and then click
"format", then "cell", the "date" under "category" was highlighted.

I try to change the format in that column by clicking "format" and then
"cell", I can't make the right hand side date coincide with the left hand
side date. It seems that the right hand side date is "mm/dd/yy" whereas the
left hand side is "dd/mm/yy".

Questions:

1. Why they have different format after the installation?
2. How do i make them have the same format.

Thank you very much.

ml