Reviews and recommendations are unbiased and products are independently selected. Postmedia may earn an affiliate commission from purchases made through links on this page. You think you know Excel.

Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number. This can be hard-coded inside double quotes or a reference to a cell ...