Works: Retaining Formulas in a SS Using Text and Tabs Format (155906)


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 Q155906

SUMMARY

When you save a Works spreadsheet in the Text and Tabs format, you will lose the formula information. You can prevent this by converting the formulas to text strings before saving the document as a text file. The following steps are necessary to save the file as text and preserve the formulas.

MORE INFORMATION

Before saving the spreadsheet in Text and Tabs format, follow these steps:

  1. Open the spreadsheet in Works.
  2. Under the Edit menu, click Select All.
  3. Under the Edit menu, click Replace.
  4. In the Find What box, type = (the equal sign).
  5. In the Replace With box, type "= (a quotation mark and equal sign).
  6. Click Replace All.
To change your formulas back, reverse the procedure above, replacing "= (quotation mark and equal sign) with = (equal sign).

NOTE: The Replace command is not available in Works for Windows 2.0.

You can now save the spreadsheet in Text and Tabs format and retain your formula information.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbinfo KB155906
©2004 Microsoft Corporation. All rights reserved.