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

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Importing from Data Hub: Incorrect or Missing Mappings in Target Model
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.