### Problem

Sometimes when trying to integrate large number of fields into Totango it is possible that these values come in scientific notation. When this happens they need to be converted from Scientific notation to a number value so that they show up in Totango correctly and any calculations are done correctly as well. To do this we need to create a formula using the Customer Data Hub Field Functions.

### Solution

To load these values in scientific notation into Totango you have to leave them as a text-type field and use the function editor to create a formula to convert them into the correct format.

- VALUE(
)**<Field In Scientific Notation>**

***Note**: To add your field click the "+" button next to it on the left-hand panel.

- VALUE(TEXT(VALUE(
), "$0.00"))**<Field In Scientific Notation>**

**Please make sure that the field that is in scientific notation stays as a text field before you try to use the function editor. Otherwise, the function editor will not work.**

### More on Customer Data Hub Function Editor

- Customer Data Hub Field Functions
- Totango Field Functions Formulas
- Customer Data Hub Source Field Formatting

### For Further Assistance

If this article does not resolve the issue, please contact Totango Support for further assistance.