# Input field value and group separator for numbers **URL:** \ **Category:** Ask for Help\ **Created:** [January 3, 2024, 12:40pm UTC](https://community.glideapps.com/t/input-field-value-and-group-separator-for-numbers/69202 "2024-01-03T12:40:14Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![rexcadiz](https://avatars.discourse-cdn.com/v4/letter/r/8baadc/32.png) [@rexcadiz](https://community.glideapps.com/u/rexcadiz)\ **Post date:** [January 3, 2024, 12:40pm UTC](https://community.glideapps.com/t/input-field-value-and-group-separator-for-numbers/69202/1 "2024-01-03T12:40:14Z")
Hello, I have a calculator where I have a few fields for large numbers. One example is annual sales in millions. However I can’t make the group separator appear with the entered value. Since numbers are large I’m sure users will make mistakes or/and will be confused because the amount of zeros is substantial. When they enter 1000000 I want the input field automatically display it as 1,000,000 The group separator is ON in the data, but the interface doesn’t honor that setting. Thanks in advance. ![Screenshot 2024-01-03 at 13.32.26](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/0/d0f1a667b18535dd55e348c090ef0eaec1128b14.png) ![Screenshot 2024-01-03 at 13.33.18](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e65ffd6ad8ef807e370cc134d28c35b427802e8f.png) ---
**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:** [January 3, 2024, 12:46pm UTC](https://community.glideapps.com/t/input-field-value-and-group-separator-for-numbers/69202/2 "2024-01-03T12:46:45Z")
Entering the field will show what you entered… the value in the column will be display as you set it up ---
**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:** [January 3, 2024, 12:52pm UTC](https://community.glideapps.com/t/input-field-value-and-group-separator-for-numbers/69202/3 "2024-01-03T12:52:48Z")
What you could do is have the user enter the value in millions, and then use a math column to multiply it in the backend. For example, if the value should be 1,360,000, enter it as 1.36 ---
**Author:** ![rexcadiz](https://avatars.discourse-cdn.com/v4/letter/r/8baadc/32.png) [@rexcadiz](https://community.glideapps.com/u/rexcadiz)\ **Post date:** [January 3, 2024, 12:56pm UTC](https://community.glideapps.com/t/input-field-value-and-group-separator-for-numbers/69202/4 "2024-01-03T12:56:51Z")
I understand that, but I need the value to be displayed with group separators right in the input field and not only in database. Otherwise UX isn’t good… ---
**Author:** ![rexcadiz](https://avatars.discourse-cdn.com/v4/letter/r/8baadc/32.png) [@rexcadiz](https://community.glideapps.com/u/rexcadiz)\ **Post date:** [January 3, 2024, 12:58pm UTC](https://community.glideapps.com/t/input-field-value-and-group-separator-for-numbers/69202/5 "2024-01-03T12:58:21Z")
Thanks Darren. Too complicated and requires a separate field in the calculator with already quite a few fields. Also the users aren’t ‘techy’ so I have to keep in mind that any confusion will likely result in them not using the tool… ---
**Author:** ![rexcadiz](https://avatars.discourse-cdn.com/v4/letter/r/8baadc/32.png) [@rexcadiz](https://community.glideapps.com/u/rexcadiz)\ **Post date:** [January 3, 2024, 12:59pm UTC](https://community.glideapps.com/t/input-field-value-and-group-separator-for-numbers/69202/6 "2024-01-03T12:59:21Z")
Btw this is what I’m doing already. It’s 10000000 in millions , because the real value is many billions ---
**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:** [January 3, 2024, 1:18pm UTC](https://community.glideapps.com/t/input-field-value-and-group-separator-for-numbers/69202/7 "2024-01-03T13:18:53Z")
the simple solution will be to have a text component showing the column where that field is recorded… you can use HTML to make it position in a better place ---
**Author:** ![rexcadiz](https://avatars.discourse-cdn.com/v4/letter/r/8baadc/32.png) [@rexcadiz](https://community.glideapps.com/u/rexcadiz)\ **Post date:** [January 3, 2024, 2:27pm UTC](https://community.glideapps.com/t/input-field-value-and-group-separator-for-numbers/69202/8 "2024-01-03T14:27:13Z")
yeah I tried this but still it makes things look cumbersome ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [January 3, 2024, 2:54pm UTC](https://community.glideapps.com/t/input-field-value-and-group-separator-for-numbers/69202/9 "2024-01-03T14:54:34Z")
Yeah, they appears in data but not in entry fields