Do you want enter numbers and text into same column? When yes, then reconsider the idea!

Use tables to enter any data - with header row at top, and every table column dedicated for single type of data. In case you need to present entered data in some different format, create report(s) sheets, which read data from data entry sheet(s), and display it in wanted format.