Number of decimal places

Hi,

thanks for your question!

I don’t understand. How many digits do they have now? Why don’t you type them in with two digits?

Regards,
Tobias

Hey,

sorry for the confussion.

For example I have the number 77 which I want to be displayed as 77.00, or more precicely if the price is 77euro 90 cents, i want it to be displayed as 77.90 . TablePress shows it as 77.9 which I assume is a default setting.

Cheers,
Andrey

Hi,

no, TablePress does not change the text that you type in.
So, just type in the numbers with the desired decimal places. Or are those the results of some formulas in the table?

Regards,
Tobias

I see. That is good to know.

Probably the problem is the excel formating or the transition. In excel I have them with two digits after the decimal sign. However, the decimal sign is a comma for my excel. I think TablePress uses a dot as a decimal sign?

Do you think that might be the problem?

Cheers,
Andrey

Hi,

TablePress treats everything as text. However, the decimal sign is important if you are using the sorting function. That by default requires a dot (you can change it with this TablePress Extension: https://tablepress.org/extensions/datatables-sorting-plugins/ ).

TablePress will import the data in the same way as it is written in the CSV file. So, you should check what the data looks like in the CSV file, e.g. with a text editor like Notepad.

Regards,
Tobias

Hey,

I actually import the data from a .xlsx file. With a .csv file the numbers appear correctly, however there is a well-known problem with saving cyrillic files as .csv from MS Office :)) My data is in cyrillic .

Cheers,
Andrey

Just downloaded the OpenOffice’s spreadsheet program and saved it as a UTF-8 .csv.

All perfect ??

Thanks for the help, Tobias!

Cheers,
Andrey

Hi,

yes, those UTF-8 issues are really terrible ??
Good to hear that you found a way! ??

Best wishes,
Tobias