All Categories Utilities Issues/Questions Subscriber file turns to 0

Subscriber file turns to 0

Question:

I download subscriber file but the last digit turns to 0. Please help.

Answer:

The probable cause of this is because you opened it using Excel. Excel automatically formats the cell values to a number - which results into converting some digits to zero.

Do not save it on excel - or do not modify the downloaded file using excel. You can check the fullness of the values if you use a text editor instead or you can also open it using “Import data”  method in excel.

Please watch this Youtube tutorial how to open a CSV in excel properly.

https://www.youtube.com/watch?v=ebnNy5yEkvc

Was this article helpful?

Thanks for your feedback!