# Glide putting ' symbol in values

**URL:** <https://community.glideapps.com/t/glide-putting-symbol-in-values/41784>\
**Category:** Ask for Help\
**Created:** [May 9, 2022, 3:33pm UTC](https://community.glideapps.com/t/glide-putting-symbol-in-values/41784 "2022-05-09T15:33:34Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![fromthermproducao](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fromthermproducao/32/42026_2.png) [@fromthermproducao](https://community.glideapps.com/u/fromthermproducao)\
**Post date:** [May 9, 2022, 3:33pm UTC](https://community.glideapps.com/t/glide-putting-symbol-in-values/41784/1 "2022-05-09T15:33:34Z")

</div>

in text entry, if i put a number in the google sheet, the value have a ’ symbol before, ex: '30, my formulas cant work with this

---

<div class="post-metadata">

**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:** [May 9, 2022, 3:56pm UTC](https://community.glideapps.com/t/glide-putting-symbol-in-values/41784/2 "2022-05-09T15:56:55Z")

</div>

What if you use a number entry instead? If numbers are entered into a text entry, it will be saved as text, meaning the ’ character is added so the google sheet recognizes numbers as text instead of numbers.

---

<div class="post-metadata">

**Author:** ![fromthermproducao](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fromthermproducao/32/42026_2.png) [@fromthermproducao](https://community.glideapps.com/u/fromthermproducao)\
**Post date:** [May 9, 2022, 4:15pm UTC](https://community.glideapps.com/t/glide-putting-symbol-in-values/41784/3 "2022-05-09T16:15:13Z")

</div>

i tried now, dont work too, always put a quotation mark before the number ;(

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/43a094a1c6129ed4c6e998bc2c77d9174381460b.png)

---

<div class="post-metadata">

**Author:** ![fromthermproducao](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fromthermproducao/32/42026_2.png) [@fromthermproducao](https://community.glideapps.com/u/fromthermproducao)\
**Post date:** [May 9, 2022, 4:15pm UTC](https://community.glideapps.com/t/glide-putting-symbol-in-values/41784/4 "2022-05-09T16:15:55Z")

</div>

![imagem_2022-05-09_131538921](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/d/2d202cb43ed262b52bbc1f7a9c6d86f315de9ec7.png)

---

<div class="post-metadata">

**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:** [May 9, 2022, 4:33pm UTC](https://community.glideapps.com/t/glide-putting-symbol-in-values/41784/5 "2022-05-09T16:33:04Z")

</div>

Is your column type set to numeric in the glide data editor?

---

<div class="post-metadata">

**Author:** ![fromthermproducao](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fromthermproducao/32/42026_2.png) [@fromthermproducao](https://community.glideapps.com/u/fromthermproducao)\
**Post date:** [May 9, 2022, 4:45pm UTC](https://community.glideapps.com/t/glide-putting-symbol-in-values/41784/6 "2022-05-09T16:45:37Z")

</div>

yes, and in the google sheet too.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/1/817037645c2046cf8e2686cf2f600832c1513825.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 9, 2022, 11:31pm UTC](https://community.glideapps.com/t/glide-putting-symbol-in-values/41784/7 "2022-05-09T23:31:41Z")

</div>

What if you start them from scratch, creating two new columns, set it to “number” in the Glide editor and then try writing to it using number entries like you do here?

---

<div class="post-metadata">

**Author:** ![fromthermproducao](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fromthermproducao/32/42026_2.png) [@fromthermproducao](https://community.glideapps.com/u/fromthermproducao)\
**Post date:** [May 10, 2022, 12:47pm UTC](https://community.glideapps.com/t/glide-putting-symbol-in-values/41784/8 "2022-05-10T12:47:40Z")

</div>

i will try today.