Converting Formulas
The formulas featured in this article are used to convert formats. To use formulas with different types of fields you sometimes need to convert the format of the fields used in the formula. For example, if you want to use a drop down field with number values in it, inside of a numeric formula you would need to convert the drop down (text) to a numeric value.
You can copy and paste any one of these formulas into the formula box.
Drag and drop your text fields to replace "field". You can also put numeric values in place of fields.
- Convert Text to Numeric
This will convert text that represents a number to a number format:
Value(text field)
- Convert Date to Numeric
This will convert a date expressed as text to the number that represents the date:
DATEVALUE(date field)
- Convert Numeric to Text
This will convert a numeric value to a text value:
TEXT(numeric field)
- Convert Numeric to Text Formatted
This will convert a numeric value to text in a specific format:
TEXT(numeric field,format)
TEXT(numeric field,"$0.00")& "per hour"