Export to excel inconsistent format between tabs

Certified Senior Developer

I am exporting a report that contains data on two tabs and am using two Export DSE to Excel nodes.

Some tabs share the same columns but there is inconsistency in the format.

1. Column Headers are bold in tab 2, not in tab 1

2. ID formatted as number in one, text in another

An ID from Appian that should be exported is 000002233403600018

In the respective column, the ID is exporting differently on each tab:

Tab 1: 

2.2334E+12

Tab 2: (this cell also says an alert message: The number in this cell is formatted as text or preceded my an apostrophe).

000002233403600018

How can I apply the formatting from tab2 to tab1?

  Discussion posts and replies are publicly visible

Parents Reply Children