Click the 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 apostrophe (') before the number. For instance, in the image below, the number 300 appears as '300, if the number if formatted as text.
To convert a cell:
Click on the cell to select it.
Click on the cell to select it. Notice the cell
edit box contains an ' before the number.
Click the Data | Text to Number command.
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