Excel Format Issues - Copy and Paste

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

Accepted answers

All comments

HimanshuRaj

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

Alessio_Pagliano

Ciao @LucaRicci ,

I think there should be 3 areas you should check. :

System Settings
Browser Settings
Excel Settings

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!

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
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