Works: Replace Command Doesn't Match Month in Spreadsheet or DB (150265)


The information in this article applies to:

  • Microsoft Works 3.0
  • Microsoft Works 3.0a
  • Microsoft Works 3.0b
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 4.0a
This article was previously published under Q150265

SUMMARY

When you use the Find command in the Database or Spreadsheet modules of Works, Find will match month names like, January, or month abbreviations like, Jan., but the Replace command may not. The Replace command will match month names that have been entered as text, but not if the month name in the cell is a numerical date formatted to display as text.

MORE INFORMATION

Works treats dates as numbers; January 1, 1900 is assigned a date value of 01, and every day after that increases the number by 1. Thus, January 1, 2000 has a serial date number, 36526. It is important to note, even if you format the field or cell to display a month name, Works calculates that value as a number.

The valid serial date range is 1/1/1900 to 6/3/2079. Any date entered outside this range will be treated as text.

  1. Copy the information you want to perform the Replace on, from the Spreadsheet or Database List view.
  2. Paste the information into a new Word Processor document.
  3. Use the Replace command, on the Edit menu, to replace month names or abbreviations as desired.
  4. Select all the information in the Word Processor document and click Copy.
  5. Paste the information into spreadsheet cells or database List view fields where it was copied from.
NOTE: This procedure will convert your dates from numeric values to text entries.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbinfo KB150265
©2004 Microsoft Corporation. All rights reserved.