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

If you’ve got a celebrity story, video or pictures get in touch with the Metro.co.uk entertainment team by emailing us ...