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

Microsoft designed Excel to work well with large numbers, but there are times when things can go awry. For example, when folks enter numbers that are more than 11 digits, they are converted right away ...

If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 free Excel tutorials. Bill "MrExcel" Jelen is the author of 67 books about ...