Happy Business Starts Here

Leading Zeros are wiped off in Developer Tools

Rajkumar
Zuora Support

Leading Zeros are wiped off in Developer Tools

Question:

 

Cannot save csv with a field that has leading zeros, when I load into Developer Tools, the zero's are no longer there.

 

Solution:

This is an issue with MS Excel which is not allowing Leading 0s with Number or General format. We need to format the row in Text format.

 

Dev Tools File.png

 

Dev Tools File output.png

Dev Tools File output2.png

 

An Example link to convert Number into Text format in Excel - https://www.ablebits.com/office-addins-blog/2014/10/10/excel-convert-number-text/

 






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √