# Convert number to text?
**URL:** https://community.parabola.io/t/convert-number-to-text/1100
**Category:** Ask a question
**Created:** [September 24, 2020, 4:11pm UTC](https://community.parabola.io/t/convert-number-to-text/1100 "2020-09-24T16:11:07Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Theresa\_Phamduy](https://community.parabola.io/u/Theresa_Phamduy)
#### Post date: [September 24, 2020, 4:11pm UTC](https://community.parabola.io/t/convert-number-to-text/1100/1 "2020-09-24T16:11:07Z")
Hi there, is it possible to convert number fields to text format? For example, zip codes (numbers that can start or end with 0) become truncated - I want to convert this field to text to avoid this issue. Thanks!
---
### Author:  [@brian](https://community.parabola.io/u/brian)
#### Post date: [September 24, 2020, 9:42pm UTC](https://community.parabola.io/t/convert-number-to-text/1100/2 "2020-09-24T21:42:24Z")
Hey Theresa, are you seeing the truncation in another tool, such as Google Sheets, or in Parabola?
---
### Author:  [@Tessa\_T](https://community.parabola.io/u/Tessa_T)
#### Post date: [March 1, 2021, 9:35pm UTC](https://community.parabola.io/t/convert-number-to-text/1100/3 "2021-03-01T21:35:06Z")
Hey @brian — I’m having a similar issue with Sheets, the data going in for an ID is “2020031601534919777025” but when it gets written to Google Sheets it’s listed as “2.0200316015349198e+21”
What can I do to fix this? Thanks for your help!
---
### Author:  [@daniel](https://community.parabola.io/u/daniel)
#### Post date: [March 2, 2021, 12:53am UTC](https://community.parabola.io/t/convert-number-to-text/1100/4 "2021-03-02T00:53:17Z")
Hey @Tessa_T,
Are you able to share an example of how that Id exists within Parabola? You may be able to quickly adjust this in Google Sheets by changing the number formatting settings in your column.
It’s also worth double-checking to see if there are any hidden characters or spaces hiding in that cell. Use the “Clean data” step in Parabola to ensure your formatting remains the same throughout that column.
---
### Author:  [@Tessa\_T](https://community.parabola.io/u/Tessa_T)
#### Post date: [March 2, 2021, 1:28am UTC](https://community.parabola.io/t/convert-number-to-text/1100/5 "2021-03-02T01:28:38Z")
Hey @daniel — thanks for your help. Unfortunately the data already gets reformatted in the Sheets step in Parabola when I preview it. Tried the Clean Data step also. Is there a way to convert a number to a string/text in Parabola?
---
### Author:  [@daniel](https://community.parabola.io/u/daniel)
#### Post date: [March 2, 2021, 2:38am UTC](https://community.parabola.io/t/convert-number-to-text/1100/6 "2021-03-02T02:38:51Z")
Thanks for letting me know. If you have an “Expand with JSON” step, can you try this out before that step?
1. Use the “Insert Text Column” step to create a new column called `Id (Formatted)`
2. Insert the values from your original ID column using curly brackets preceded by a random character. Your value could look like `'{ID column}`
After your “Expand with JSON” step:
1. Use a “Find and replace” step to find all instances of `'` in your `Id (Formatted)` column and replace it with a blank value.
The data should remain consistent since we’re actually creating that value as a string in Parabola. Here’s a basic outline of what that will look like:
You can always use a “Select columns” step to remove the original ID column from your table. Let me know if that helps with your formatting!
---
### Author:  [@Tessa\_T](https://community.parabola.io/u/Tessa_T)
#### Post date: [March 2, 2021, 3:20am UTC](https://community.parabola.io/t/convert-number-to-text/1100/7 "2021-03-02T03:20:24Z")
Unfortunately, no luck with those steps @daniel
---
### Author:  [@daniel](https://community.parabola.io/u/daniel)
#### Post date: [March 2, 2021, 3:37am UTC](https://community.parabola.io/t/convert-number-to-text/1100/8 "2021-03-02T03:37:35Z")
Hey @Tessa_T,
When you added the “Insert Text Column” step to create a new column, did you insert an apostrophe `'` before the column value in curly brackets?
Double-check to make sure the value is entered as `'{ID column}`, not `{ID column}`.
If that still doesn’t fix it, feel free to send us an email at [help@parabola.io](mailto:help@parabola.io) and we can take a look at your flow together!
---
### Author:  [@Tessa\_T](https://community.parabola.io/u/Tessa_T)
#### Post date: [March 2, 2021, 3:44am UTC](https://community.parabola.io/t/convert-number-to-text/1100/9 "2021-03-02T03:44:17Z")
Thanks @daniel — I’ve submitted a ticket 👍🏽