# Change type of cell? From number to Text **URL:** \ **Category:** Feature Requests\ **Created:** [August 4, 2020, 1:09pm UTC](https://community.glideapps.com/t/change-type-of-cell-from-number-to-text/13557 "2020-08-04T13:09:11Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Raph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raph/32/9481_2.png) [@Raph](https://community.glideapps.com/u/Raph)\ **Post date:** [August 4, 2020, 1:09pm UTC](https://community.glideapps.com/t/change-type-of-cell-from-number-to-text/13557/1 "2020-08-04T13:09:12Z")
Hello I have in my spreadsheet a cell with text that is labeled as a number… I’d like to modify to text so that I can put a conditional visibility of it if it _“contains”_ some specific text. Talking about the bottom left on the image, “Portfolio” and “Potfolio (text)” ![Capture d’écran 2020-08-04 à 15.05.24](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4ce537ecef517b27029987d36d9c0aeed0261c30.png) At the moment impossible, Glide just proposes equals doesn’t equal etc, all related to numbers whereas it is text. Thank you, Raphael ---
**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:** [August 4, 2020, 1:28pm UTC](https://community.glideapps.com/t/change-type-of-cell-from-number-to-text/13557/2 "2020-08-04T13:28:08Z")
I agree, it would be nice to alter the column type after the fact. I have a few that are listed incorrectly, probably due to bad data or empty columns when I initially created the app. As a workaround, you could create a new column through the glide data editor, with the type you want, then migrate all of your data to the new column. A little bit of work, but an option if you need the conditions to work correctly. ---
**Author:** ![Raph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raph/32/9481_2.png) [@Raph](https://community.glideapps.com/u/Raph)\ **Post date:** [August 4, 2020, 1:35pm UTC](https://community.glideapps.com/t/change-type-of-cell-from-number-to-text/13557/3 "2020-08-04T13:35:14Z")
Thank you. However even in the Glide editor, Glide does not allow me either to change the type or cell or to set the configuration to user-specific, see attached : ![Capture d’écran 2020-08-04 à 15.34.01](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f62db0c0d01ccfcba7bb16c68d0ab5fbf94288d9.png) ---
**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:** [August 4, 2020, 1:39pm UTC](https://community.glideapps.com/t/change-type-of-cell-from-number-to-text/13557/4 "2020-08-04T13:39:05Z")
I realize that. That’s why I mentioned creating a new column within Glide. ---
**Author:** ![Raph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raph/32/9481_2.png) [@Raph](https://community.glideapps.com/u/Raph)\ **Post date:** [August 4, 2020, 1:47pm UTC](https://community.glideapps.com/t/change-type-of-cell-from-number-to-text/13557/5 "2020-08-04T13:47:17Z")
It works perfectly thank you (I have still a lot to learn about the power of Glide 😉 ) ---
**Author:** ![Albert\_Puig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/albert_puig/32/84707_2.png) [@Albert\_Puig](https://community.glideapps.com/u/Albert_Puig)\ **Post date:** [May 7, 2023, 3:50pm UTC](https://community.glideapps.com/t/change-type-of-cell-from-number-to-text/13557/6 "2023-05-07T15:50:37Z")
Hello Jeff, I’am trying to do same thing the other way around, means transform text to number. GHow can I migrate the date no a number column from a single text value from a split text? Thanks in advanced;) Albert Puig ---
**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:** [May 7, 2023, 4:17pm UTC](https://community.glideapps.com/t/change-type-of-cell-from-number-to-text/13557/7 "2023-05-07T16:17:35Z")
> [@Tranform a text column to a number column](https://community.glideapps.com/t/tranform-a-text-column-to-a-number-column/61448/2): > > Try using a math column, and multiply it by 1.