Microsoft KB Archive/263855

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

Article ID: 263855

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Works Suite 2000
 * Microsoft Works 2000 Standard Edition
 * Microsoft Works Suite 2001
 * Microsoft Works Suite 2002
 * Microsoft Works Suite 2003
 * Microsoft Works 6.0
 * 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.

Additional query words: w_works works2k

Keywords: kbaddin kbprb KB263855

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.