Home > eSalesTrack Help Menu > Administrator > Modules > Field Creator > eFormula > Formula - Converting

eFormula

Converting Formulas

The formulas featured in this article are specific to converting from one format to the other.  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 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"

See also