# Changing Column Type

**URL:** <https://community.glideapps.com/t/changing-column-type/12592>\
**Category:** Report a Bug\
**Created:** [July 16, 2020, 12:41pm UTC](https://community.glideapps.com/t/changing-column-type/12592 "2020-07-16T12:41:23Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kurnia\_Iqbal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kurnia_iqbal/32/315_2.png) [@Kurnia\_Iqbal](https://community.glideapps.com/u/Kurnia_Iqbal)\
**Post date:** [July 16, 2020, 12:41pm UTC](https://community.glideapps.com/t/changing-column-type/12592/1 "2020-07-16T12:41:23Z")

</div>

Hi,  
I have column, actually its Number Column Type, But its Always show as Date Value and ask Display…  
I Dont Know how to change this type column to Number Column like I want…  
Because when I want to edit, the column type can’t change (grey font)

Please help me…  
thank you…

---

<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:** [July 16, 2020, 1:19pm UTC](https://community.glideapps.com/t/changing-column-type/12592/2 "2020-07-16T13:19:17Z")

</div>

Go to your sheet and change the format of the cells there, then refresh the Editor.

---

<div class="post-metadata">

**Author:** ![Kurnia\_Iqbal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kurnia_iqbal/32/315_2.png) [@Kurnia\_Iqbal](https://community.glideapps.com/u/Kurnia_Iqbal)\
**Post date:** [July 16, 2020, 2:20pm UTC](https://community.glideapps.com/t/changing-column-type/12592/3 "2020-07-16T14:20:45Z")

</div>

it doesn’t work

---

<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:** [July 16, 2020, 2:32pm UTC](https://community.glideapps.com/t/changing-column-type/12592/4 "2020-07-16T14:32:15Z")

</div>

What are your values currently showing in the Sheet for that column? Can we have some screenshots?

---

<div class="post-metadata">

**Author:** ![Kurnia\_Iqbal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kurnia_iqbal/32/315_2.png) [@Kurnia\_Iqbal](https://community.glideapps.com/u/Kurnia_Iqbal)\
**Post date:** [July 16, 2020, 5:44pm UTC](https://community.glideapps.com/t/changing-column-type/12592/5 "2020-07-16T17:44:27Z")

</div>

here is in the sheet

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0dd85d2eb5e986dfc3ca6fa2e903f813d8c57e35.png)

---

<div class="post-metadata">

**Author:** ![Kurnia\_Iqbal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kurnia_iqbal/32/315_2.png) [@Kurnia\_Iqbal](https://community.glideapps.com/u/Kurnia_Iqbal)\
**Post date:** [July 16, 2020, 5:45pm UTC](https://community.glideapps.com/t/changing-column-type/12592/6 "2020-07-16T17:45:07Z")

</div>

and here is in the app editor

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/16b1e5a0f336f736155c8f220a977e81d37e6c5e.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:** [July 16, 2020, 5:51pm UTC](https://community.glideapps.com/t/changing-column-type/12592/7 "2020-07-16T17:51:38Z")

</div>

Try a new column, pre formatted it as numbers in the Sheet, copy the content of your original column to the new one and refresh the Editor to see if it changes.

You can also add a number column inside Glide, it will automatically generate a new column in your sheet. You can copy the data to that new column.