Best answer

How to convert a number to text?

  • 30 September 2022
  • 4 replies
  • 288 views

I have a Google Form which has the field “ИНН” and this field can start from zero (“0”) and has a numeric format (I checked this with the Zapier ISTEXT(value) formula)

But i need save this “0”

I use “Lookup Spreadsheet Row in Google Sheets” action to write values to Google Sheets and after that action “0” lost

Before action: 
 


After action:

 

 

Can you help me? What function should i use? 

icon

Best answer by MohSwellam 3 October 2022, 18:02

View original

4 replies

Userlevel 7
Badge +8

Hi @devopsuser , 

 

This might be from Google Sheets side maybe? I mean is this column in Google Sheets set to format Text already and not Auto ? 

 

Hi @devopsuser , 

 

This might be from Google Sheets side maybe? I mean is this column in Google Sheets set to format Text already and not Auto ? 

 

In Google Sheets this column already in Text format (it didn't help)

The values are truncated after Zapier in the table

Example below:

 


The red values are smaller in length due to the clipped zero at the beginning

Userlevel 7
Badge +8

Hi @devopsuser 

 

I found this resource for google sheets tips on adding the leading zero, I think it can help 

 

https://www.oksheets.com/add-leading-zeros/

 

I would use the apostrophe one :)

Userlevel 7
Badge +9

Hey there, @devopsuser! I wanted to check in and see if you were able to get this sorted with @MohSwellam recommendations? 🤗

Keep us posted! We’d love to know!

Reply