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

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.