Microsoft KB Archive/103766

Mac Works: Text Numbers Become Numbers If Document Saved as Text

PSS ID Number: Q103766 Article last modified on 10-22-1998

3.0 4.0

MACINTOSH

================================================================ ==

The information in this article applies to:

 == Microsoft Works for the Macintosh, version 3.0 and 4.0 == 

= SUMMARY =

If a Microsoft Works spreadsheet is saved out as a text file and re-opened into Works as a spreadsheet, numbers that were previously entered as Text will be converted to number values and will be formatted as numbers.

To enter a number as text so that it will not be converted when the document is saved as text, precede the number with an OPTION+SPACEBAR (press the OPTION key and SPACEBAR together). This number will retain its text formatting even after being saved as text and re-opened into a Works spreadsheet.

You may also enter a number as text by preceding the number with an open quote, for example, &quot;999. (See page 173 of the User’s Guide.) This method, however, will not retain its text formatting if the file is saved as text then re-opened. Numbers formatted in this way will re-open formatted as numbers.

= MORE INFORMATION =

Entering a number as text is most commonly used for serial numbers or part numbers in a worksheet that may be misinterpreted by Works as dates.

KBCategory: kbother KBSubcategory: macworkskb

= Additional reference words: 3.00 mac m_eXcel mwksss =

Version : 3.0 4.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.