BLANK space in the place of '#'

[Former Member]

Hai

In my reporting , im getting '#' in the place of no values for some records for a particular InfoObject.

My client wants either BLANK space in the place of "#' .

How can i get like this .

Please let me know how can i get like this

kumar

[Former Member]

In the workbook you can use a macro to remove the #. Write the macro in between:

<b>SAPBExonRefresh (queryID As String, resultArea As Range)</b>

<Write the VBA code here>

<b>End Sub</b>

Hope this helps.

Bhargava

[Former Member]

Hi,

Check the following link:

http://sap-img.com/business/removing-hex-sign-in-analyzer-report.htm

Regards,

Bhaskar