Set the correct options under Tools-Options-International
Also make sure the default settings on your computer are OK (I assume
they are) Start-Control Panel- Regional and Language Options - Regional
Options.
--
John James
------------------------------------------------------------------------
John James's Profile:
http://www.excelforum.com/member.php...o&userid=32690
View this thread:
http://www.excelforum.com/showthread...hreadid=531855