Microsoft KB Archive/46497

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 19:23, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q46497 to Microsoft KB Archive/46497 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.