Table of contents
Collapse the table of content
Expand the table of content


Owen Duncan|Last Updated: 10/5/2018
1 Contributor


Decodes a value from a textual representation, value, and interprets it as a value with an appropriate type. Value.FromText takes a text value and returns a number, a logical value, a null value, a DateTime value, a Duration value, or a text value. The empty text value is interpreted as a null value.

Value.FromText(value as text, optional culture as nullable text)  


valueThe value to transform.
optional cultureA text value corresponding to the culture values supported on your version of Windows, such as "en-US". If the culture is not specified, the current user culture is used. For a list of culture names, see National Language Support (NLS) API Reference.


Value.FromText("1") equals 1  
Value.FromText("2012/5/16") equals #date(2012,5,16)  
Value.FromText("null") equals null  
Value.FromText("somevalue") equals "somevalue"  
© 2018 Microsoft