Answering for anyone stumbling on this question today. For Microsoft 365 and later, zeros can be avoided by appending an empty string to the Indirect's output. Though keep in mind your output will become a string. This works on array outputs as well.

Indirect(Reference) & ""