Why is Inputlookup CSV truncating my data?

[shealerner]

I use the inputlookup file.csv and the zeros on numbers are deleted ex. 00075 to 75, it also truncates some numbers ex. 20170505.00002 to 20170505

How do I get it to input CSV data exactly as it is?

[vnravikumar · Accepted solution]

Hi @shealerner

There could be one reason that if you are editing csv file with MS-Excel, you may get the above problem.

[shealerner]

Thank you, I was opening the file in Microsoft Excel which was truncating the values.

[vnravikumar]

Welcome. Please accept my answer.