zero value when import from excel

Options

We are importing data from excel into Smartsheet. In excel, we hide the zero values, but when we import the data in smartsheet, the "0" shows up. We import invoice data, sometimes these are 3 lines only, sometimes these are 10 lines. In Excel we hide any "0" value when we the linked cell is empty (so we have formula's/ linked cells for upto 10 lines, but only lines with data show up).

As we import into SMartsheet and print invoices in "generate documents" through PDF's, these PDF's show all the "0"'s.

Is there a easy way to hide the "0" values from smartsheet, so the generated documents only populate the cells with data/ values?

Answers