Man illustrationFlower illustration



Estimated reading: 1 minute 64 views

Format activity is used for converting the specified column in an Excel file to the desired format.

*Excel nameReference name of Excel which will be opened.
RangeExcel sheet range from which to fetch data.
Sheet nameName of the sheet to work in Excel. If no added, it takes the first sheet by default.
*FormatFormats cells for dates, text, currency, time
Note: * Fields selected with are required, others are optional.

You can use the Excel name as shown in the example.


You can use the Range as shown in the example.


You can use the Sheet name as shown in the example.


You can use the Format as shown in the example.

For date:


For TC:


For text:


For currency:

₺ #, ## 0; -₺ #, ## 0

For hours: nn

These examples can be increased on demand or by using ready-made formats in excel.