Text To Number

Click the Data | Data | Text to Number command to convert text strings in selected cells to numbers. This command will eliminate extraneous zeros and convert text to simplified numeric format.

 

To determine if the cell contains a number formatted as text, click on the cell to select it. The cell edit box displays the number with an ' before the number. For instance, in the image below, the number 3 appears as '003, if the number if formatted as text.

 

To convert a cell:

  1. Click on the cell to select it.

Click on the cell to select it. Notice the cell

edit box contains an ' before the number.

  1. Click the Data | Data | Text to Number command.

  2. The cell converts to numeric format, if the cell had been a text number. The cell edit box now displays the number without the ' before it.

The cell now shows the number right aligned and the

cell edit box does not contain an ' before the number.

 

See Also

Transform

Number to Text

Data Tab Commands