2.1.1061 Part 1 Section 18.17.7.337, VALUE

  • Article

a.   The standard does not specify what happens if string argument is not formatted as number, currency, date or time.

In Office, if string is not formatted using a number, currency, date, or time format, #VALUE! Is returned.