How to pass a number format to Excel output

[kakooo16]

I'm having issue to format my cells to number because it's always the type text that is displayed

job design

tfixedflowinput (my number (double)) -> tFileOutputExcel

I have this warning in the cell of my Excel (the number in this cell is in text format)

How could i force my column to be numeric and not text based format ?

Using TOS 7.3.1

[Anonymous]

You cannot do this with the standard Excel components. They simply pass the data to Excel. The formatting in Excel is not covered by these.

There is a set of components written by a user called @Jan Lolling​ where you can control a lot more. You can find these here....

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F542&pi=marketplace%252F1%252Fproducts%252F542%252Fitems%252F2992