Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.

Lucas Downey is the co-founder of MoneyFlows, and an Investopedia Academy instructor. Michael Boyle is an experienced financial professional with more than 10 years working with financial planning, ...

Investopedia contributors come from a range of backgrounds, and over 25 years there have been thousands of expert writers and editors who have contributed. Nonce, short for "number used only once," is ...