How to convert column format from General to Number

Help Studio
,
1

Please help me to change a column format from “General” to “Number”

2

@Komal_Valagadde

Please use format cells activity pass the range you want to format and select the number format from options

https://docs.uipath.com/studiox/docs/tutorial-formatting-cells#:~:text=In%20the%20Excel%20file%2C%20select%20the%20entire%20column%20A%2C%20and,cell%20formatting%20should%20be%20copied.

Cheers

3

I want achieve this requirement in Studio not StudioX.

4

Hi Komal,

If you are trying to preserve the column format in the excel as ‘Number’, you will have to do that in Excel before the datatable is written into the sheet.

If you are planning to write into a blank excel, my suggestion is to copy an empty template excel file instead (with all the formatting done in that template excel) into an output location and write your datatable into that location. That will ensure that the column format is ‘Number’ instead of ‘General’.

5

@Komal_Valagadde

The description is for studiox but same works for studio as well…there is no change…you can check the activities

Cheers