data validation

Vlatko1990 

Excuse me for the inconvenience, but we need precise information in order to be able to provide you with an acceptable solution.

I cannot see from your text from which program you are importing this text and not which version of Excel you are dealing with. Knowing the operating system would also be a plus for a suggested solution. An inserted file (without sensitive data) would be best where you could explain your subject.

If it is not absolutely necessary, please do not send a photo, you cannot tell from the photo whether it could be due to the file (if the error only occurs in this file).

To keep it short, a little more info would help.

Nevertheless, here ... some information about it.

Format numbers as text

https://support.microsoft.com/en-us/office/format-numbers-as-text-583160db-936b-4e52-bdff-6f1863518ba4?ui=en-us&rs=en-us&ad=us

Import or export text (.txt or .csv) files

https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba?ui=en-us&rs=en-us&ad=us

Thank you for your understanding and patience

Hope I was able to help you.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here