It has been noticed that when exporting data from a 3rd party software, at times the data contains "zero length strings" for columns where numeric data is expected.


What are zero length strings?

Please refer this link to know more about zero length strings


Alternative 1

Steps to remove Zero length Strings

1. Select the Full Column which contains zero length strings (one column at a time)
2. Select "Data >> Text to Columns"
3. Select "Delimited"
4. Untick all the delimiters and select the Text qualifier as "none"
5. Click the "Finish" button
6. Follow the steps 1 to 5 for all the Columns
7. Save the Excel sheet


After this, run udiMagic to import the Excel sheet into Tally.


Alternative 2

If you are using a Formula to fetch the data from another Excel sheet (or another source), kindly note the correct way to import numeric data :


Incorrect way :  =If(P2=0,"",P2)


Correct way   :  =If(P2=0,0,P2)


PS: 
Notice that the incorrect way shown above returns "zero length string" instead of 0 (numeric zero)