Convert Exponential Form to Number Form

[thead]

I have Text(255) Column in Caspio Table that has data which is in Exponential Form. I want these data to be in Number form instead of the Exponential one.

The Exponential form comes from Excel as it can only store up to 15 digits before it becomes Exponential.

Is this possible or is there any workaround to achieve this?

 

Thank you.

[April]

Hi Thead,

It seems that it is not possible to turn the Exponential Form to your desired value as the data is already presented like that during import, and any subsequent numbers are rounded off to 0.

What you may do is format the whole column in Excel as Text before you put in the data, so, it will not get manipulated. You can then import it to Caspio.

Hope this helps.

[IamNatoyThatLovesYou]

Hello Thead, 

You can also use a formula or calculated value for this to change it into a number if you will be using it in a DataPage. 

CONVERT(FLOAT, [@field:])

I hope this helps you.

[cheonsa]

Just to add to the previous response, here are some helpful links regarding formula and calculated values:

https://howto.caspio.com/function-reference/

https://howto.caspio.com/datapages/datapage-components/calculated-values/

https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/