Forum Discussion

Derrickcfulton's avatar
Derrickcfulton
Copper Contributor
Oct 10, 2024

EXCEL Pasting dates from SAP - one PC pastes as date, another as text

When I paste a table from SAP into a new excel sheet, the dates format appropriately as dates and all is well;  When a co-worker does exactly the same thing from an identical PC, same version of Exc...
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Oct 11, 2024
Apart from updating the settings as I said in my other reply, consider importing the data into Excel directly, rather than pasting. SAP has many tools to get your data into Excel in a more reliable fashion.
  • Derrickcfulton's avatar
    Derrickcfulton
    Copper Contributor
    Oct 16, 2024
    Thanks for the reply, there were no differences between the 2 systems that we could see.
    We will continue to convert the date columns.

    Thanks
    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Oct 16, 2024

      Derrickcfulton What about the options of Excel, are they the same? Especially these:

       

       

      • Derrickcfulton's avatar
        Derrickcfulton
        Copper Contributor
        Oct 16, 2024
        We did check these and any other potential date related settings. I will have another look at the intl.cpl to double check.

        Thanks

Resources