Date format differs while exporting a file in different type of system (eg.MS Excel and Open office)

Hello,

We have been facing a strange issue while exporting a file from Anaplan in two different systems.

The time dimension format differs when we import a file in MS Excel and Open office.

Is it true that if we implement a project for a customer everyone in the team should have only one type of system ( either MS excel or Open office )?

For example: In the open office it will be the same as Match names

Whereas in MS Excel it MM-DD-YYY

Accepted answers

All comments

Misbah

@Richa123

Not confident on this but I would believe so.

This problem may arise only if you are using Periods like MMM YY etc. Having said that I feel that it should be uniform across all systems. Let me tag @MarkWarren

Misbah

MarkWarren

The name matching has to be in the format "MMM YY", so in Excel you'd need to set that as a custom formatting. There can be some differences between systems in how they format dates but most systems will allow for a numeric date output which is more commonly recognized. Just a minor thing that Excel has decided to put in a hyphen in their format of "MMM-YY".
Unfortunately Anaplan doesn't allow for a custom name format here, so has to be done at source.

Richa Pathak

Thank you, Will try this approach.

bhubeshrana

Change the custom format to "mmm yy" in excel like this

Quick Links

Can you help?

Unanswered questions

Update email id
Can anyone please explain how to update my registered email ID jn Anaplan.
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.…