Forum Discussion
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 Excel etc. it pastes as General and the date column needs to be converted.
Any Ideas why this would be happening?
6 Replies
- 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.
- 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
- On both systems, press the windows key and type intl.cpl and press Enter.
Now compare those two windows. If everything there is the same, click the Additional settings button on both systems and compare those as well, especially the Date tabs.
