Datatype column set to string but leading zeros removed

Hi,

I am writing a range to an excel file. However, values for one column can contain leading zeros (e.g. 015). When I look at the result, the leading 0 is omitted.
I have set the datatype for the column to string for the specific column, yet it is not reflected when I write the data.

Any hints/tips how to fix this?

Thanks a lot!

Kris

@krisvandenbergh
give a try with explicit filling up with:

sometimes it helps to put a ’ before the value when writing to Excel

Also have a check on this component from Connect: