This is a migrated thread and some comments may be shown as answers.

Comma as thousand separator and dot as decimal separator

3 Answers 854 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Jonatan
Top achievements
Rank 1
Jonatan asked on 04 May 2016, 10:54 AM

How do I Switch the settings for the thousand separator and the decimal separator?

 

currently the decimal value : 2510.012 is displayed as 2,510.012

I want to make it so it is displayed as: 2.510,012

3 Answers, 1 is accepted

Sort by
0
Helen
Telerik team
answered on 05 May 2016, 08:18 AM
Hi Jonatan,

Here you may find more information how to format strings and numbers in Spreadsheet.

Hope it helps.

Regards,
Helen
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Jonatan
Top achievements
Rank 1
answered on 06 May 2016, 06:16 AM

Hi Helen

I cannot from that page deduce any way of switching the decimal separator and the thousand separator.

Is there a working solution somewhere?

please note that it has to work with number validation.

 

0
Alex Gyoshev
Telerik team
answered on 06 May 2016, 07:49 AM

Hello Jonatan,

The decimal point and number formatting is governed by the currently set application culture. See the globalization help topic. I believe you are looking for kendo.culture("da-DK").

Regards,
Alex Gyoshev
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Spreadsheet
Asked by
Jonatan
Top achievements
Rank 1
Answers by
Helen
Telerik team
Jonatan
Top achievements
Rank 1
Alex Gyoshev
Telerik team
Share this question
or