How to pad Excel data with zeros

Question

I would like to pad Excel data with zeros to match digits of each data.

Answer

To pad data with zeros, you need to write the numeric value as a string.
Please use the [Format Number] logic to convert a numeric value to a string of any format.

Format Number
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Mapper/DecimalFormat.htm

When writing with Excel Connector in a specified String format, [Style] must be set to [Specify format].
For details on [Style], please refer to the following manual.

[Write]
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/excel_put_data.htm

As described in the above manual, [Format] for writing can be used for "Date" or "Number" type data.

-Supplementary information

The following remark is described about [Insert], but the Excel connector cannot pad data with zeros even if [String] is set on the Excel side in advance because in the xlsx format, the current operation internally handles data in the [Standard] type and then writes the data according to the format of the destination document.

The format of the inserted position will be applied. 
Even when [Specify format] is specified in [Style], it will be ignored.

If the above applies, please use the xls format or uncheck the [Insert] checkbox.