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

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