Microsoft KB Archive/46497

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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

The information in this article applies to:
- Microsoft Works for the Macintosh, versions 1.x and 2.0

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.