How to limit the number of decimal points

[Laura228]

Hi, I am just trying out Caspio and have imported a table. I would like to limit the number of decimal points to 2. How can I do this?

Thanks.

[sbelini]

Hi,

you can set this up in the localications.

Regards.

[Laura228]

Thanks, I checked there and it shows two decimal points, which is what I would like, but the tables I imported lost something in translation and have 8 or more extra decimals. (Which are not present in Excel sheet that I imported.)

[sbelini]

Please have in mind that in the localizations you can control how the data is displayed, not how the data is stored.

i.e. if you have a record with a value equal 13.3422034 and set in the localizations only two decimal digits, you will only see 13.34 in you DataPage, but the data in your table will still be 13.3422034.

Another tip: when importing data from a spreadsheet, make sure the cells are of generic type (custom/special cell types in excel might cause some unexpected behavior with the data when imported into Caspio).

[telly]

Hi @Laura228,
 

For additional information and visualization: https://howto.caspio.com/datapages/datapage-components/field-formatting-options/

[NailDyanC]

Hi, just to add. You can format it using formula as well: https://howto.caspio.com/function-reference/#:~:text=Str(number%2C length %2C precision)

[ParkLoey]

In relation to sbelini's response, localizations only affects how you show the records on a DataPage level. You can check this article to know more about the formatting options that can be done through there:

https://howto.caspio.com/localizations/formatting-options/

[imJihyo]

heyaa everyone! Just wanted to suggest using task as well for manipulating/updating values you import to your tables. maybe this can help in limiting the number of decimals as well:

https://howto.caspio.com/tasks/