Format error and Headers not in Bold

[Laxmi_Movva]

Hi,

We are getting format error for numerical values in the Alteryx output file (both input and output files in .xlsx format). Attached error snip.

Also we are looking for column headers in bold without using table tool. Could someone help please.

[DawnDuong]

Hi @Laxmi_Movva 

if you do not want to use table tool, i can think of 2 ways:

1) convert your numeric fields to String. The toString formula allows you to specify the format.

https://help.alteryx.com/current/designer/conversion-functions

2) fix the format in excel then output specified range. You can find in the community discussion on how to preserve format in excel output 

dawn