Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/102421

From BetaArchive Wiki
Knowledge Base

Works: Converting Numbers Entered as Text into a Numeric Format

Article ID: 102421

Article Last Modified on 11/15/2004


  • Microsoft Works 2.0 Standard Edition
  • Microsoft Works 2.0a
  • Microsoft Works 3.0 Standard Edition
  • 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 Q102421


If valid numeric entries have been inserted into a Spreadsheet or in the list view of the Database file as text (that is, on the toolbar, a quotation mark ["] is in front of the entries), they can be converted into the numeric format. This can be done by copying the entries into a Word Processor document and pasting them back into the original file.


Numeric data entered into the Spreadsheet or Database file as text can be converted into a numeric format by following these steps:

  1. Highlight the data that needs to be converted.
  2. From the Edit menu, click Copy.
  3. From the File menu, click Create New File. Select Word Processor.
  4. In Works 2.0:

In the new Word Processor document, click Paste from the Edit menu. The data will now appear in the Word Processor file.

In Works 3.0 and later:

In the new Word Processor document, click Paste Special from the Edit menu and select Unformatted Text. Click OK.

  1. In Works 2.0:

On the Select menu, click All.

In Works 3.0 and later:

On the Edit menu, click Select All.

  1. From the Edit menu, click Copy.
  2. Close the Word Processing document without saving and return to the original file.
  3. Position the cursor in the first cell in which the data should be placed (for example, if the original data was copied from A5 to A15 in the Spreadsheet file, select A5.)
  4. From the Edit menu, click Paste.

This converts the data into a numeric format.

NOTE: This only works if the values can be interpreted as a valid numeric entry by Works. Valid numeric entries are composed of numbers and certain special characters, such as the comma, the dollar sign, the E when used to denote an exponent, a period, and the percent sign.

Additional query words: 2.00 2.00a 4.00 3.00 3.00a 3.00b 4.00a 4.50 4.50a ss db number convert change changing conversion w_works

Keywords: kbinfo KB102421