value() Function

Converts text representing a number into an actual number or datetime.


value ( text, [format] )

text: (Text) The string of characters to be converted into a number or date.

format: (Text) The input format of the value, such as "mm/dd/yyyy".


Any Type


The text value checks for decimal points, slashes, hyphens, and colons to determine whether you are trying to have the function return a date or a number.


You can experiment with this function in the test box below.

Test Input

value("12/13/2005","mm/dd/yyyy") returns 12/13/05 12:00 AM GMT

Open in Github Built: Fri, Mar 11, 2022 (04:59:07 PM)

On This Page