Microsoft KB Archive/155906

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

Article ID: 155906

Article Last Modified on 11/15/2004

-

APPLIES TO


 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 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.

Additional query words: 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a w_works

Keywords: kbinfo KB155906

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.