Excel Core Book
Get our FREE guide on Excel when you subscribe to our free newsletter
Changes given text string (that should have been a number) to a number.
Syntax of Excel Value formula:
=Change to numbers (this text)
=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.