# Can we put seperation ' into numbers? **URL:** \ **Category:** Ask for Help\ **Created:** [October 10, 2022, 5:18pm UTC](https://community.glideapps.com/t/can-we-put-seperation-into-numbers/51397 "2022-10-10T17:18:10Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Carter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carter/32/45004_2.png) [@Carter](https://community.glideapps.com/u/Carter)\ **Post date:** [October 10, 2022, 5:18pm UTC](https://community.glideapps.com/t/can-we-put-seperation-into-numbers/51397/1 "2022-10-10T17:18:10Z")
Hello, i have a quick question, can we put seperation text into a number ? Like number 1 000, i want see 1’000, or 12’000 etc… Thank you ! ---
**Author:** ![Luther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luther/32/17929_2.png) [@Luther](https://community.glideapps.com/u/Luther)\ **Post date:** [October 10, 2022, 5:22pm UTC](https://community.glideapps.com/t/can-we-put-seperation-into-numbers/51397/2 "2022-10-10T17:22:33Z")
Did you try using the native separator via the number column in the data editor? ---
**Author:** ![Carter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carter/32/45004_2.png) [@Carter](https://community.glideapps.com/u/Carter)\ **Post date:** [October 10, 2022, 5:24pm UTC](https://community.glideapps.com/t/can-we-put-seperation-into-numbers/51397/3 "2022-10-10T17:24:32Z")
Yes the native seperation it’s a space between numbers, it’s good but our client want a ’ into numbers. ---
**Author:** ![Luther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luther/32/17929_2.png) [@Luther](https://community.glideapps.com/u/Luther)\ **Post date:** [October 10, 2022, 5:46pm UTC](https://community.glideapps.com/t/can-we-put-seperation-into-numbers/51397/4 "2022-10-10T17:46:00Z")
oh okay, i see…that a bit above my skillset for now but i am confident some of our geniuses on this platform will be able to assist. Just hang in there ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [October 10, 2022, 11:51pm UTC](https://community.glideapps.com/t/can-we-put-seperation-into-numbers/51397/5 "2022-10-10T23:51:17Z")
Hola @Carter I suppose your client wants this: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/f/efd7ba3e43db7871fcd351380bfac599b1a0143e.png) If so, the steps are: 1. Convert your Number (using the group separator) to Text via a Template column. 2. Create a new Template column using your previous Template column as source and replace each “.” with an " ’ " ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/494e5fa9164d4af65b8f1650cf5f137e8db4f570.png) This should be enough to make your client happier! 😉 Saludos! ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [October 11, 2022, 12:29am UTC](https://community.glideapps.com/t/can-we-put-seperation-into-numbers/51397/6 "2022-10-11T00:29:45Z")
Notice that the column “Number with new format” (with the new separator) should probably only be used for display purposes, not for math. I’ll quote Mark on this: “The number column is a number. The template column is text. Glide tries its best to parse it as a number, but sometimes it gets it wrong.” So once a number has gone through the template column, one cannot use the output reliably for math. If you do, check the results carefully. I’ve done a few tests and the results are false with math beyond the template column if the precision in the very first number column is 1 (so set precision to 1.0 or higher). Also, the separator will revert to the usual separator, so really changing the separator should be the very last step before display. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 11, 2022, 1:29am UTC](https://community.glideapps.com/t/can-we-put-seperation-into-numbers/51397/7 "2022-10-11T01:29:14Z")
> [@gvalero](#): > > Create a new Template column using your previous Template column as source and replace each “.” with an " ’ " Worth noting that this won’t work for all users in all countries. There are a few different ways to represent a large number. Some countries use commas, some use periods, some use spaces, and some use a combination of all 3. [https://docs.oracle.com/cd/E19455-01/806-0169/overview-9/index.html](https://docs.oracle.com/cd/E19455-01/806-0169/overview-9/index.html) This is something that I prefer not to try and mess around with. Just leave it to the user to configure their device so it’s displayed as per their personal preference. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [October 11, 2022, 1:56am UTC](https://community.glideapps.com/t/can-we-put-seperation-into-numbers/51397/8 "2022-10-11T01:56:23Z")
Well, the warning must be: - Only to be used for display purposes - Only for integer numbers (no decimals) - The number has a group separator - The group separator can be: “,” or “.” or " " - You have to replace each “,” or “.” or " " with " ’ " in your template can we celebrate the agreement with a 🍕 🍕?? 😉 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 11, 2022, 2:00am UTC](https://community.glideapps.com/t/can-we-put-seperation-into-numbers/51397/9 "2022-10-11T02:00:49Z")
> [@gvalero](#): > > can we celebrate the agreement with a 🍕 🍕?? 😉 …and beer please 🍻 🙂 ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [October 11, 2022, 9:25am UTC](https://community.glideapps.com/t/can-we-put-seperation-into-numbers/51397/10 "2022-10-11T09:25:35Z")
> [@Darren\_Murphy](#): > > This is something that I prefer not to try and mess around with. 👆 I think this is the most important piece of information. Changing the group separator by hand feels extremely hacky and you are looking for trouble. I wouldn’t do it. It’ll probably break eventually and your client will have much worse to complain about. ---
**Author:** ![Carter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carter/32/45004_2.png) [@Carter](https://community.glideapps.com/u/Carter)\ **Post date:** [October 11, 2022, 11:55am UTC](https://community.glideapps.com/t/can-we-put-seperation-into-numbers/51397/11 "2022-10-11T11:55:58Z")
Thanks all, i think the better option it’s not use it, and for me (switzerland) it’s not working so…