# Error during column datatype change \[Jun 02\]

**URL:** <https://community.nocodb.com/t/error-during-column-datatype-change-jun-02/512>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 10:01am UTC](https://community.nocodb.com/t/error-during-column-datatype-change-jun-02/512 "2022-11-03T10:01:35Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:01am UTC](https://community.nocodb.com/t/error-during-column-datatype-change-jun-02/512/1 "2022-11-03T10:01:35Z")

</div>

> 🙋‍♂️ **saki** _asked_

## 

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/056974ed8811599e3c18000313af36997fb93b04.png)

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:01am UTC](https://community.nocodb.com/t/error-during-column-datatype-change-jun-02/512/2 "2022-11-03T10:01:36Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### You had a column with type ‘SingleLineText’. It had numbers stored in its rows. You get an error when you try to edit its datatype to ‘Number’.

#### 

#### Is this observation correct?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:01am UTC](https://community.nocodb.com/t/error-during-column-datatype-change-jun-02/512/3 "2022-11-03T10:01:37Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### I could see this error. Looks like the empty cell is causing problem (may be is being treated as a string).

#### 

#### I was able to edit column from text \> number of clearing the contents of empty cell explicitly. (right click on the cell - click clear data).

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:01am UTC](https://community.nocodb.com/t/error-during-column-datatype-change-jun-02/512/4 "2022-11-03T10:01:38Z")

</div>

> 🙋‍♂️ **saki** _replied_

#### yes, this was the case. the type is single line text, but even when i try to change it to Long Text I get the same error.

 ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/58e0d865a0e38abe0834e9a54016d2dc512f5a28.png)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:01am UTC](https://community.nocodb.com/t/error-during-column-datatype-change-jun-02/512/5 "2022-11-03T10:01:39Z")

</div>

> 🙋‍♂️ **saki** _replied_

#### so this is a bug, right?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:01am UTC](https://community.nocodb.com/t/error-during-column-datatype-change-jun-02/512/6 "2022-11-03T10:01:40Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### yes

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:01am UTC](https://community.nocodb.com/t/error-during-column-datatype-change-jun-02/512/7 "2022-11-03T10:01:42Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/981509085298053180)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)