Skip to Content
author's profile photo Former Member
Former Member

I have a problem with Bex, showing Pound symbol instead of $.

Hi,

I have a problem when i run a report it is showing Pound symbol instead of doller ($) symbol,

Kindly help on how to rectify this issue.

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 11, 2010 at 06:36 PM

    Hello Rajesh,

    There are three notes regarding this issue:

    Check which one fits to your problem:

    1473369 Currency translation issue with Excel

    1252724 Currency symbol $ is not displayed in Excel

    1347721 Decimal Points of US currency is Missing in Excel

    Let me know if persist.

    Best Regards,

    Edward John

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Rajesh,

      You don't need to apply exactly the Patch 6.

      You have to apply the latest version. On the link below you can find the latest patch for Business Explorer and SAPGUI:

      http://service.sap.com/swdc

      -> Software Downloads

      -> Support Packages and Patches

      -> Support Packages and Patches Entry by Application Group

      -> SAP Frontend Components"

      -> SAP GUI FOR WINDOWS

      -> SAP GUI FOR WINDOWS 7.10 CORE

      -> win32

      -> gui710_19-10002995.exe

      _ -> BI ADDON FOR SAP GUI

      -> BI 7.0 ADDON FOR SAP GUI 7.10

      -> Win32

      -> bi710sp13_1300-10004472.exe

      |_ -> BI ADDON FOR SAP GUI

      -> BW 3.5 ADDON FOR SAP GUI 7.10

      -> Win32

      -> bw350gui710_10-10004473.exe

      Thank you.

      Edward

  • Posted on Oct 15, 2010 at 07:34 AM

    HI ,

    This is a work out which can solve your problem if your issue is still open

    Please try the below steps

    To replace pound values with $ or a meaningful description. To do this, attach your code directly to a query using a Visual Basic for Applications (VBA) macro. You can use this feature only with Excel workbooks. Run your query and follow menu path Tools>Macro>Visual Basic Editor

    If you have not used Visual Basic or VBA before, talk to someone who has before you perform this step. Remember to save your query as a workbook to ensure the system invokes your VBA code and replaces your numbers when the workbook refreshes.

    Dim x as range

    For Each x In resultArea

    If x.Value = "#" Then

    x.Value = "$"

    End If

    Next X

    Regards

    KP

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.