Date Format
 

Dear friends,
Everytime I type the Date of 10 Dec. 2005 as 10/12/2005, it converted to
12/10/2005 and it refused to be modified when I try to adjust it from
FormatCells.

--


Regards,


-------------------------------------------------
Mahmoud Metwally Ali
Jaicorp IT Manager
Office Tel. : (202) 3471495/361
Mob. : (2010) 5195169

Hi Mahmoud

Sounds like you have to change your regional settings. Go
start|Settings(?)|Control Panel, select regional settings, select Date and
time, and change your date fromat to dd/mm/yyyy

"Mahmoud Metwaly" wrote:

Dear friends,
Everytime I type the Date of 10 Dec. 2005 as 10/12/2005, it converted to
12/10/2005 and it refused to be modified when I try to adjust it from
FormatCells.

--


Regards,


-------------------------------------------------
Mahmoud Metwally Ali
Jaicorp IT Manager
Office Tel. : (202) 3471495/361
Mob. : (2010) 5195169

See response in public.excel.

--
HTH

Bob Phillips

"Mahmoud Metwaly" wrote in message
...
Dear friends,
Everytime I type the Date of 10 Dec. 2005 as 10/12/2005, it converted to
12/10/2005 and it refused to be modified when I try to adjust it from
FormatCells.

--


Regards,


-------------------------------------------------
Mahmoud Metwally Ali
Jaicorp IT Manager
Office Tel. : (202) 3471495/361
Mob. : (2010) 5195169