It is possible to convert text format to number format (change format of the cell) In Open Office Calc (Excel). If the text cell contains a number and text to number format conversion is made, the cell will contain a single quote character directly in front of the number.
via How to convert text to number format in cells | Ambience.