How to change the default data type of a column?

[Gao-Jun]

I use RubyXL to generate a template xlsx file for users to input data.
For one column, say 'Student No.', some data start with 0, like 0011.
I hope the user can input this directly without changing the data type of the column to text.

I know that I can change the data type of a cell, but the number of the data is various, so I don't know how many lines an user will input.

Is there any way to change the default type of a column?

Thank you.