+ Reply to Thread
Results 1 to 11 of 11

SAP Dowload ---> Excel - Data being displayed with decimal points vs. commas

  1. #1
    Registered User
    Join Date
    07-17-2018
    Location
    Kentucky
    MS-Off Ver
    2016
    Posts
    5

    SAP Dowload ---> Excel - Data being displayed with decimal points vs. commas

    I'm doing a relatively simple export from SAP to Excel. The data displays correctly in SAP when I look at it on the screen. Numbers would have the expected format as I've set in my user preferences in SAP (1,000.00 as an example). When I export the data and open in Excel, the number are displayed with a decimal point in place of the comma (1.000.00 as an example). In Excel I've looked at my preference and tried find and replace but neither solution has worked for me.

    SAP View.jpg

    Excel View.jpg

    Thanks for your help

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: SAP Dowload ---> Excel - Data being displayed with decimal points vs. commas

    Select the range, Format Cells - Custom Format - apply this format _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    07-17-2018
    Location
    Kentucky
    MS-Off Ver
    2016
    Posts
    5

    Re: SAP Dowload ---> Excel - Data being displayed with decimal points vs. commas

    Thanks for the quick response. I gave it a try, but the decimals still remain in place

    custom format.jpg

  4. #4
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: SAP Dowload ---> Excel - Data being displayed with decimal points vs. commas

    You have the option to not show the decimals on ribbon.
    https://chandoo.org/wp/show-decimal-points-if-needed/

  5. #5
    Registered User
    Join Date
    07-17-2018
    Location
    Kentucky
    MS-Off Ver
    2016
    Posts
    5

    Re: SAP Dowload ---> Excel - Data being displayed with decimal points vs. commas

    I've tried that too. It's almost as if the cell is locked, at is won't let me reformat or remove the decimal places in all of the standard ways.

  6. #6
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: SAP Dowload ---> Excel - Data being displayed with decimal points vs. commas

    See if is stored as number or text with ISNUMBER. The use text to column nu fix it. Otherwise, uploaded a small sample

  7. #7
    Registered User
    Join Date
    07-17-2018
    Location
    Kentucky
    MS-Off Ver
    2016
    Posts
    5

    Re: SAP Dowload ---> Excel - Data being displayed with decimal points vs. commas

    I've uploaded an example sheet if you're able to take a look. Thanks
    Attached Files Attached Files

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: SAP Dowload ---> Excel - Data being displayed with decimal points vs. commas

    I'd look at the SAP export file (I assume it's text). I expect you'll find the data looks just like Excel imports it.

    Otherwise, you can use a formula:

    A
    B
    C
    D
    E
    F
    G
    1
    Net Order Price Currency POQuantity GRQuantity
    2
    200.27
    USD 73.216.000 73.216.000
    73216
    73216
    E2: =--SUBSTITUTE(C2, ".", "", 1)
    3
    200.27
    USD 77.792.000 77.792.000
    77792
    77792
    4
    200.27
    USD 91.520.000 91.520.000
    91520
    91520
    5
    182.89
    USD 32.032.000 32.032.000
    32032
    32032
    6
    182.89
    USD 22.880.000 22.880.000
    22880
    22880
    Entia non sunt multiplicanda sine necessitate

  9. #9
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,781

    Re: SAP Dowload ---> Excel - Data being displayed with decimal points vs. commas

    wrong Formula
    Last edited by CARACALLA; 07-17-2018 at 02:02 PM.

  10. #10
    Registered User
    Join Date
    07-17-2018
    Location
    Kentucky
    MS-Off Ver
    2016
    Posts
    5

    Re: SAP Dowload ---> Excel - Data being displayed with decimal points vs. commas

    That worked, thanks so much for your help!

  11. #11
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: SAP Dowload ---> Excel - Data being displayed with decimal points vs. commas

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How block insertion of values with decimal points/commas?
    By JohanVB in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-05-2017, 08:22 AM
  2. [SOLVED] event procedure to dynamically change amount of decimal points being displayed
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 04-01-2016, 10:00 AM
  3. [SOLVED] Can I make the data ranges displayed in a chart vary depending on my no. of data points
    By David Myers in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-06-2014, 02:16 PM
  4. [SOLVED] Commas to Decimal Points for separator
    By gxb101 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-10-2012, 08:05 PM
  5. Replies: 5
    Last Post: 05-02-2012, 11:05 AM
  6. How to set # of decimal points displayed?
    By earachefl in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-13-2007, 07:23 PM
  7. Replies: 1
    Last Post: 02-23-2005, 07:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1