Select to view content in your preferred language

Table to Excel — Define column datatypes/formatting

153
0
08-29-2024 02:10 PM
Status: Open
Labels (1)
Bud
by
Esteemed Contributor

When using Table to Excel:

I would like the option of defining the datatype/formatting of the fields. For example, lengthy ID numbers sometimes get formatted as scientific notation in Excel. I want to format those numbers as integers (numbers with zero decimal places) or as text.

I want to define the formatting from within the GP tool or model, not after the fact in Excel.