The numbers in the csv data file are not overt

Hi! I’ve conducted some pilot research but its data in the csv file looks like this:

I did this Split text into different columns with the Convert Text to Columns Wizard but it didn’t fix the problem this time. The numbers which you can see in the abovementioned screenshot are not overt in this one, as you can see. How can I fix the problem? Thanks in advance.

Are you referring to the numbers being replaced by ######? I believe that’s an Excel thing, you should be able to change it in the Cell Format settings.

Yes! That’s the issue, but I am unable to solve it.

Oh, I did it thank you!

1 Like