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, ...

Timothy Li is a consultant, accountant, and finance manager with an MBA from USC and over 15 years of corporate finance experience. Timothy has helped provide CEOs and CFOs with deep-dive analytics, ...