#NumericZero appears as '- on excel
Summary#NumericZero appears as '- on excel
I am using smart view client 710 and excel 2016 on windows 10.
My smart view option has always set as #NumericZero for missing or blanks. My hs function report is already formatted to use zero as -.
but lately when I open the report, the cells will show '- instead of -. I have to refresh two times to get back - and not '-.
Does anyone know why?