# Really no solution for thousand separator? **URL:** \ **Category:** Ask for Help\ **Created:** [April 3, 2023, 9:42pm UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095 "2023-04-03T21:42:07Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![pluzgi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pluzgi/32/56533_2.png) [@pluzgi](https://community.glideapps.com/u/pluzgi)\ **Post date:** [April 3, 2023, 9:42pm UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/1 "2023-04-03T21:42:07Z")
Hi guys, if i have used a glide table with a number column is there really no option to format the thousand separator with a “.” instead of “,”.? In Germany these numbers have a complete different meaning. Maybe by using the math column in a smart way? Thanks, Sabine (Already checked all format options in google sheet or airtable and imported it;-( ![Bildschirm­foto 2023-04-03 um 23.38.43](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5c66ae2aeeee8481eb30b9e28d62f0ef381a8961.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 3, 2023, 10:02pm UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/2 "2023-04-03T22:02:49Z")
@pluzgi I trust that your numbers are in columns set to numeric types? @nathanaelb would you have any thoughts on this or what other settings need to be adjusted in the browser or on the device? For further reference: > [@Formatting + language questions](https://community.glideapps.com/t/formatting-language-questions/59994): > > Hi there, just started with glide today and really like it so far. After surfing the FAQ section i couldn’t find any information on these both questions. Hope somebody can help me. We in Germany use the “.” as the thousand separator (1.000 instead of 1,000). (How) can i format number columns or “big number” fields that way? Can i translated button field or default text, like “Submit” at button or “Filter by”. If yes, where? Thanks a lot and kind reg, Sabine ---
**Author:** ![pluzgi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pluzgi/32/56533_2.png) [@pluzgi](https://community.glideapps.com/u/pluzgi)\ **Post date:** [April 4, 2023, 7:48am UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/3 "2023-04-04T07:48:21Z")
@Jeff_Hager, yes the columns are defined as number type. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [April 4, 2023, 8:34am UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/4 "2023-04-04T08:34:28Z")
You can use a Java column and format your numbers to German: ![Screen Shot 2023-04-04 at 4.33.30 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/a/fa57de712fe4370a1b51bbac60acb29d3f5357a5.jpeg) `return p1.toLocaleString('de-DE')` for display purposes only ---
**Author:** ![pluzgi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pluzgi/32/56533_2.png) [@pluzgi](https://community.glideapps.com/u/pluzgi)\ **Post date:** [April 4, 2023, 9:16am UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/5 "2023-04-04T09:16:35Z")
Hi @Uzo , Amazing, thanks! If you sometimes come to a solution where this can be used for calculation too please send me a note. Have a wonderful day. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [April 4, 2023, 9:42am UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/6 "2023-04-04T09:42:59Z")
… hmm… just keep both numbers 😉 ---
**Author:** ![pluzgi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pluzgi/32/56533_2.png) [@pluzgi](https://community.glideapps.com/u/pluzgi)\ **Post date:** [April 4, 2023, 10:02am UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/7 "2023-04-04T10:02:37Z")
Yep, for big numbers it works, but unfortunately you can’t use this approach for graphs and legends like this because the the formatted numbers/computed column doesn’t relate to the graph. ![Bildschirm­foto 2023-04-04 um 12.00.48](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/5/359eef0c44e1d58cceb4ca986dac5b116a33cae2.jpeg) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [April 4, 2023, 10:04am UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/8 "2023-04-04T10:04:51Z")
hmmm… yep, not good for that. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [April 4, 2023, 10:19am UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/9 "2023-04-04T10:19:22Z")
But there is a solution to that! LOL ![Screen Shot 2023-04-04 at 6.18.31 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/2/225408167838d3b8cbfb4e5ead0060b379d722e8.png) ---
**Author:** ![pluzgi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pluzgi/32/56533_2.png) [@pluzgi](https://community.glideapps.com/u/pluzgi)\ **Post date:** [April 4, 2023, 11:41am UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/10 "2023-04-04T11:41:59Z")
Great, how did you reach that? I’ll send a 🍪 for an answer.😉 ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [April 4, 2023, 11:47am UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/11 "2023-04-04T11:47:03Z")
Hhahahahaha… pizza? I like German Beer 😉 [![beer button](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/c/bc4c4aae122fc66671de33f98c2f94a9a21d2249.png)](https://code-book-desktop.glideapp.io/dl/54886d) 1. Create a template column with the name and amount from the Java column plus € character. 2. Uncheck the show values in legend box. 3. Put the template in Labels. 4. Put the regular number in Values. ---
**Author:** ![pluzgi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pluzgi/32/56533_2.png) [@pluzgi](https://community.glideapps.com/u/pluzgi)\ **Post date:** [April 4, 2023, 1:24pm UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/12 "2023-04-04T13:24:51Z")
It was a cookie 😂 But for that you’ll get 🍺 I’m really happy now - looks like that now: ![Bildschirm­foto 2023-04-04 um 15.24.20](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/b/9be36ef12de5d831b2e2d17e891618ab3a63f660.jpeg) Thanks a lot, @Uzo! ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [April 4, 2023, 1:29pm UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/13 "2023-04-04T13:29:03Z")
Na zdrowie! ---
**Author:** ![pluzgi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pluzgi/32/56533_2.png) [@pluzgi](https://community.glideapps.com/u/pluzgi)\ **Post date:** [April 4, 2023, 2:42pm UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/14 "2023-04-04T14:42:55Z")
@Uzo, if you don’t mind… I’ll have to use your flow today;-) There is another separator challenge for the standard graph. Do you have an idea for that too? Here i can’t uncheck the legend values.;-( ![Bildschirm­foto 2023-04-04 um 16.40.22](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/f/8fe650a560de6dc01f3ccfacf8088d8c57776fcf.png) Thanks in advance. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [April 4, 2023, 3:26pm UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/15 "2023-04-04T15:26:58Z")
There is no control over this chart values look. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [April 5, 2023, 3:27pm UTC](https://community.glideapps.com/t/really-no-solution-for-thousand-separator/60095/16 "2023-04-05T15:27:08Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.