Hi all,
I am having an issue when it comes to copying and pasting data from Anaplan to Excel. In fact, the data format changes from number to general or scientific.
I don't know how to fix this problem, may anyone help me?
Thanks in advance,
Luca
Hi @LucaRicci
After copy pasting the number from Anaplan to Excel, you'd then need to adjust data format in excel to change it to number. Sometime, it works this way.
Hope, this resolves
Ciao @LucaRicci ,
I think there should be 3 areas you should check. :
I don't know which OS, Excel version or Browser you've got but I would go on that order.
Looking at your post it seems the issue is connected to the system settings and/or Language settings (I would check there and on the Advanced options first). You can easily access it by typing intl.cpl in the search box of your computer, in Windows.
Then I would check the browser settings as in Chrome the language drives the date format. Three-points menu : Settings > Advanced > Languages.
And finally I would check the advanced options in Excel, but I doubt the problem is there.
Feel free to like this post/mark the post as answered/resolved if it helps/resolves your issue.
Ciao!
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
