"Number" type questions not allowing to put decimal | Community
Skip to main content
Answered

"Number" type questions not allowing to put decimal

D

Hi Everyone, 

 

I set up one of my question as a “number” question, but I have noticed that my users can’t insert a number with decimal. Ex: 53,4 - Typeform will only allow rounded number like 53. 

To avoid this, I have changed the question type to text. But I am using this value in a googlesheet (reported automatically via Zappier) and as it is a text type question, I can’t do calculation with that value in my googlesheet. 

 

does anyone know how to allow decimals in number type questions?

 

Thanks a lot!

Deborah

Best answer by john.desborough

@Deborah LB - welcome back to the community!

 

in Google Sheets, you can use the VALUE() function to covert your text  into a number. 

ie if you have text string “826” sitting in cell A4, you can put the following in cell A5 → =value(A4)

and it will return the numeric value in cell A5

des

View original

2 replies

john.desborough
Forum|alt.badge.img+6
  • john.desboroughCertified Partner
  • Certified Partner & Champion
  • 5279 replies
  • Answer
  • May 3, 2021

@Deborah LB - welcome back to the community!

 

in Google Sheets, you can use the VALUE() function to covert your text  into a number. 

ie if you have text string “826” sitting in cell A4, you can put the following in cell A5 → =value(A4)

and it will return the numeric value in cell A5

des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
D
  • Deborah LB
  • Author
  • Explorer
  • 4 replies
  • May 18, 2021

Hi @john.desborough !! thanks for your help on this one! 

 

Liz
john.desborough
2 people like this
  • Liz
    Liz
  • john.desborough
    john.desborough

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs