MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting text to values

Posted by Jacco Brand on July 17, 1999 2:27 AM

I have imported a pricelist from Word 97 to Excel 97. All the columns are fine but for one thing. The column containing the actual price has become a text-field from which I cannot calculate. How can I convert a text to a value?

Posted by Ed on July 19, 1999 12:19 PM

The function "VALUE" converts a text string that represents a number to a number.
The following is from the help file


Text is the text enclosed in quotation marks or a reference to a cell containing the text you want to convert. Text can be in any of the constant number, date, or time formats recognized by Microsoft Excel. If text is not in one of these formats, VALUE returns the #VALUE! error value.


You do not generally need to use the VALUE function in a formula because Microsoft Excel automatically converts text to numbers as necessary. This function is provided for compatibility with other spreadsheet programs.


VALUE("$1,000") equals 1,000

VALUE("16:48:00")-VALUE("12:00:00") equals "16:48:00"-"12:00:00" equals 0.2, the serial number equivalent to 4 hours and 48 minutes.

Posted by Steve on July 27, 1999 2:49 PM

There is a different answer if this didnt work. Let me know and I will forward it to you.