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.