Do you have some example workbook???
I tried using Data Interpreter just now and it turned those zeroes into nulls. Does anyone know if there's a manual way to clean it?
Thanks for the reply. I need to create a dummy workbook as I've been told that I should not be sharing the finalized data source with anyone outside of my organization.I'll follow up on this if I feel that I need an answer better than "Use the Data Interpreter".