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

When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number. If ...