System code 00 gets imported via data sink as 0 in SoapUI 5.1.2

Question

Please guide me on how to import data from excel into SoapUI with the 0 prefixed before the no.

For example in my Excel data file, the parameter for type code is 00.

But when I import it via datasource it imports as 0.

Please guide on how to fix this? I have attached screenshots

bagochips · Accepted Answer

ajaysuresh, if you format your excel to text it should import from excel as 00. I do this all of the time so it should work for you.

Forum Discussion