Microsoft KB Archive/39569

Works: Numbers Followed by “a” or “p” Converted to Numbers

PSS ID Number: Q39569 Article last modified on 06-10-1996

2.00

MACINTOSH

= SUMMARY =

In a spreadsheet, Microsoft Works will read numbers between 10 and 24 followed by an “a” or a “p” as a time rather than as text. For example, Works reads 11a as 11:00am. Therefore, the cell will display the serial number equivalent to that time, .4583333.

To enter a number between 10 and 24 followed by a “p” or an “a” as a text label, precede it with a double quotation mark, as described on Page 214 of the “Using Microsoft Works” version 2.0 manual. For example, enter &quot;11a to have 11a entered as text and displayed on the spreadsheet.

This behavior does not occur in Microsoft Works versions 3.0 and 4.0.

KBCategory: kbusage KBSubcategory: macworkskb

Additional reference words: 2.00 macworks mwkswp mwksss

=
================================================================ Copyright Microsoft Corporation 1996.