Data Storage Conflict

I created a sheet by importing from an excel file. The primary column (EmployeeID) was stored as text upon import even though it was stored as "number" in the excel file.

Subsequent data input from either a Form or manual input into the sheet is being stored as a number. Sorting the column with the mixture of text and number produces undesirable results. Is there a way to force the sheet to store the data as either one or the other?

With most of the data stored as text that would be my preference as it appears that there is no easy solution to convert text to number. It seems you have to manually strip the hidden apostrophe from the text.

Looking foward to hearing about possible solutions.


Best Answer