VALUE(text) converts a text argument to a number : VALUE « Text functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =VALUE("$1,000")
Input the formula
22.25.VALUE
22.25.1.VALUE(text) converts a text argument to a numberVALUE(text) converts a text argument to a number