You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • #NumericZero appears as '- on excel

    edited Aug 2, 2018 2:36AM in Essbase 6 comments

    Summary

    #NumericZero appears as '- on excel

    Content

    Hi,

    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?

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!