Quick Links

Reply To: Custom field‏ formulas

Home Forums Discussion Custom field‏ formulas Reply To: Custom field‏ formulas


Pls try using Val([Text23]).

The Val function listed under the category Conversion, can be used to convert any valid string expression containing
numbers to a numerical value; its syntax is Val(string). The function strips any whitespace character (i.e., blanks,
tabs, and linefeed characters) from the string passed as parameter; for example, Val(“1234 56”) returns the numeric
value 123456. The Val function recognizes only the period as the decimal separator.

Source: http://www.msptips.com/Formulas/_Built-in%20Functions%20in%20Project%20Category.html