VALUE
See Also

Converts a text string that represents a number to a number.

Syntax

VALUE(text)

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.

Remark

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.

Examples

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.



Mike F

"Asheret" wrote in message
...
I am trying to convert celss which include both numbers and text, which I
have imported. (I think from a LOTUS 123 programme) I have used both
'REPLACE' and SUBSTITUTE' but the number remaining are still treated as
text
and will not accept formats. Please Someone...HELP. Thx Ash
--
Asheret