Works: European Time (H,M,S) Entry Appears As 12:00 AM for All Times Entered (263855)


The information in this article applies to:

  • Microsoft Works Suite 2000
  • Microsoft Works 2000
  • Microsoft Works Suite 2001
  • Microsoft Works Suite 2002
  • Microsoft Works Suite 2003
  • Microsoft Works 6
  • Microsoft Works 7.0
This article was previously published under Q263855

SYMPTOMS

When you format a Microsoft Works 2000 Spreadsheet column as Time, and you enter the time in a European format (H,M,S), every time entry is converted to 12:00 AM in that column. For example, 2,53 becomes 12:00 AM. When you format a Spreadsheet column as General, and you enter the time in a European format, the comma is dropped.

CAUSE

This issue may occur because you have not changed the Windows regional settings for time.

RESOLUTION

To work around this issue, follow these steps:
  1. On the Windows taskbar, click Start.
  2. Point to Settings, and then click Control Panel.
  3. Click Regional Settings (Regional Options in Windows 2000).
  4. Click the Time tab.
  5. In the Time separator box, type a comma, and then click OK.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbAddIn kbprb KB263855
©2004 Microsoft Corporation. All rights reserved.