none
Copy Numbers - From Excel Sheet - Into PowerPivot Window looses decimal symbol? RRS feed

  • Question

  • Hi

    When I try and copy data contained in an Excel Sheet into a Power Pivot Window the Decimal Digit is lost?

    My Regional Settings for both number and currency is as follows "#,##0.00"

    Digit Grouping Symbol = Comma

    Decimal Digit = Point


    I.W Coetzer

    Thursday, November 7, 2019 6:01 AM

All replies

  • Hi,

    What version of Office did you use?

    Could you provide the language of Office you're using, go to File- Options- Language:

    And confirm if this is the same as System language.

    Regards,

    Emi Zhang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Friday, November 8, 2019 9:23 AM
    Moderator
  • Hi,

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    Regards,

    Emi Zhang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to shareexplore and talk to experts about Microsoft Office 2019.

    Wednesday, November 13, 2019 8:23 AM
    Moderator