Number

Number restricts answer format to number to avoid entry errors. Other than the basic functions shared by all question types: Required, Note, Image/Video, Invisible, Timer, Indent and Style, Range of digits can be set to put more limits on acceptable answers.

Let's say you are a math teacher and you would like to test your students' math ability with an online survey.

Survey results admin panel showing a bar chart of responses for a Number question

When designing this survey, you set the Numerical Range to limit the range of numbers that can be put down as answers. By doing so, it gives some degree of flexibility while making it easier for students to answer the questions.

Number question settings screen with the Numerical Range field

Under the condition that only numbers can be filled in this survey, it prevents typos.

Survey response page showing hint text below the question after setting the numerical range

The backend will display a bar chart with numbers, and when you hover your mouse over the chart, it will display detailed response information.

Results admin panel with the data table expanded showing calculated mean, median, and other statistics

If you click the collapse icon to the right of the data table, it will also display various calculation results of the response data (e.g., mean, median, etc.).

Example Number question used to test students' math ability

FAQs

  • Why does the leading 0 automatically disappear after I enter data starting with 0 in a number question?

This is because when the SurveyCake system determines the answer to a number question, if the answer starts with 0, the system will automatically remove the 0 to conform to the numeric format, which is why the 0 disappears.

If you want to preserve numbers starting with 0 in their entirety (e.g., phone numbers), we recommend using the "Single Line Text" question type, which will fully display the entire string of numbers starting with 0!

  • Why do some digits turn into 0 when I export to Excel after entering numbers with many digits (e.g., 18 digits) in a number question?

This issue is related to Excel's own limitations.

Because Excel automatically converts digits after 15 characters to 0 when processing numbers exceeding 15 characters (refer to this explanation for more details), we recommend you use one of the following methods to resolve this issue:

  • Follow the adjustments described in the official Excel explanation above (e.g., format cells, add quotation marks)
  • Upload the Excel file you exported from the SurveyCake backend directly to Google Drive, then open it with Google Sheets to display the complete numbers!
Summary

Number allows only numbers to be entered as answers. Combine this type of question with the Range of digits function to make filling out surveys easier and to standardize the answer format.

Master advanced
survey skills now!

Learn More
Can't find the answer you're looking for?