VALUE
Changes given text string (that should have been a number) to a number.
Syntax of Excel Value formula:
=VALUE(text)
In words:
=Change to numbers (this text)
Examples of Excel Value formula
=VALUE(“21 December 2015”) will return 42359. Once formatted in date format it will be 12/21/2015 and can be used in formula now as normal.