Export with same formatting

[CommunityMember113484]

Hi,

Is it possible to export with the same formatting as the module / dashboard ?

e.g. I have zeros showing as blanks or dashes, but when exported, it's coming up as 0 in the excel.

Thanks in advance,

[MarkWarren]

No, the underlying data will always be exported. You could, but you shouldn't, have a text representation of that data to achieve the same effect. But don't do this, Text is bad for the model and I should never have mentioned it.
I'd apply the same formatting in Excel afterwards.
Using the Excel add-in may help if you're looking to export to Excel in a specific way...
Excel Add-in Series 4 - Anaplan Technical Documentation

[Singh_Rahul]

@CommunityMember113484

You can export module as "text" as an option, you would get the desired result.

Regards,

Rahul

[CommunityMember113484]

Doesn't quite work - exporting as text creates a notepad?

[Tiffany.Rice]

@CommunityMember113484Try exporting with a file type of Excel Open XML (.xlsx).

[CommunityMember113484]

Is that only possible in the Old UX? i've got this in the NUX and it doens't provide the option?

[Tiffany.Rice]

Yes, that would have been old UX/blueprint view. See below for option in NUX.

[CommunityMember113484]

Thanks - but that doesn't work. I lose the formatting when exporting if using the methodology you've just shown.

[Tiffany.Rice]

Very odd, as it works for me. Could be something in your Excel configuration.