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

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.

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.