Microsoft KB Archive/46497

Works: Find Command Doesn’t Find Some Dates in Spreadsheet

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

1.00 1.10 2.00

MACINTOSH

= SUMMARY =

In a Microsoft Works version 2.00 spreadsheet, the Find command might not correctly identify the appropriate cells containing a date if the spreadsheet was converted from Works 1.00 or 1.10.

This problem occurs because dates entered in earlier versions of Works are treated as text, not numbers.

A date must be completely retyped in Works 2.00 in order to take on the desired format.

KBCategory: kbother KBSubcategory: macworkskb

= Additional reference words: mwksss =

Copyright Microsoft Corporation 1996.