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

With any software, the more you use it, the more hacks and shortcuts you discover, and never a truer word has been said when ...

Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder of SPYderCRusher Research. He contributes to Excel and Algorithmic Trading. David Kindness is a Certified Public Accountant ...

Subscribe Login Register Log out My Profile Subscriber Services Search PGe NEWSLETTERS PG STORE ARCHIVES OBITUARIES JOBS PUBLIC NOTICES CLASSIFIEDS EVENTS PETS ...