Hi Alex,
Thanks for the response. Here’s the step-by-step process, from preparing CSV file for upload:
Note here that I have tried to format the problematic columns (columns F and T) in the CSV file to set them as text/general/etc., and it did not help with the problem.
Next, importing this CSV file to my live database:
Preview looks correct here:
Next step also showing that the field would be imported as text:
After import, problem appears:
My url is www.diversify.space
Currently I have manually converted all the problematic cells to text in order for my search function to work, but I have more data to be uploaded, and this problem needs to be resolved.
Current property of my “Year” field is text (field type). I can’t screen capture this, but take my word for it.
If you would like my csv file, please let me know how I can attach it.
Help is appreciated.