View Single Post
  #7   Report Post  
Chris Schulze Chris Schulze is offline
Junior Member
 
Posts: 1
Default

Quote:
Originally Posted by bill_morgan View Post
Another Essbase Excel Add-in question.

When I retrieve values into Excel from our Essbase Cube (using Hyperon Excel
Add-In), null values return as text characters. Even if I format the cells,
these values appear as "0". The only way I can change the text to numbers is
through a VBA procedure that changes "0" to value 0 for all cells in the used
range.

Can anything be done (either on user end or Admin side) to get null to
return as number 0 without having to use VBA?

Thanks ...

bill morgan
Try using "(0)" instead of "0". Excel and the Add-In should interpret it as a true zero.