# In table: how to change dot to comma

**URL:** <https://community.glideapps.com/t/in-table-how-to-change-dot-to-comma/68376>\
**Category:** Ask for Help\
**Created:** [December 5, 2023, 10:42am UTC](https://community.glideapps.com/t/in-table-how-to-change-dot-to-comma/68376 "2023-12-05T10:42:19Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tomasz\_Winiarski](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tomasz_winiarski/32/66783_2.png) [@Tomasz\_Winiarski](https://community.glideapps.com/u/Tomasz_Winiarski)\
**Post date:** [December 5, 2023, 10:42am UTC](https://community.glideapps.com/t/in-table-how-to-change-dot-to-comma/68376/1 "2023-12-05T10:42:19Z")

</div>

Hi!  
so… everything was perfect until now: i just found that in four columns I have imported text values with dots.

How can I change values to numbers? And for the future - is there something like search and replace, for searching dots and replacing them with commas???

 ![Screenshot_4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/374506938cbff77d304512f23677417dba01320a.jpeg)

Regards, and thanks In advance for any help!

Tomek

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [December 5, 2023, 10:49am UTC](https://community.glideapps.com/t/in-table-how-to-change-dot-to-comma/68376/2 "2023-12-05T10:49:55Z")

</div>

You could try changing the column type to number instead of text.

---

<div class="post-metadata">

**Author:** ![Tomasz\_Winiarski](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tomasz_winiarski/32/66783_2.png) [@Tomasz\_Winiarski](https://community.glideapps.com/u/Tomasz_Winiarski)\
**Post date:** [December 5, 2023, 11:52am UTC](https://community.glideapps.com/t/in-table-how-to-change-dot-to-comma/68376/3 "2023-12-05T11:52:47Z")

</div>

OMG! The most straightforward solutions are always the most difficult! Sorry for that 🙂 question! I represent some kind of “excel-thinking” here…

THANK YOU ERIC 🙂

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [December 5, 2023, 11:58am UTC](https://community.glideapps.com/t/in-table-how-to-change-dot-to-comma/68376/4 "2023-12-05T11:58:32Z")

</div>

My pleasure glad I could help! All you need is an extra set of eyes sometimes… screenshots are key!

> [@Tomasz\_Winiarski](#):
>
> is there something like search and replace

Not really but ctrl + F or Apple + F in the data editor will do the search part

---

<div class="post-metadata">

**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:** [December 12, 2023, 11:58am UTC](https://community.glideapps.com/t/in-table-how-to-change-dot-to-comma/68376/5 "2023-12-12T11:58:36Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.