How to change cell format as text using UiPath or excel formula

Hi Team,

I have one excel and I want to chage the cell format general to text using UiPath or excel formals like vlooup or hlookup

Kindly suggest…
Please find the input and output excel files below for your reference.


HI @Baby123

You can check the video link


1 Like

Another Method @Baby123

You can also try with Format cell activity

Check out the the Tutorial

Range -> Excel.Sheet("Sheet1").Range("A1")



Hi @Gokul001 ,

I want to change entire column at a time .
Is their any excel formula to change the format.

Please suggest

This both the method will change the entire column @Baby123

Hi @Gokul001 ,

Thank You,
But I don’t know knowledge on modern activities
So, can you please send the workflow.

Thanks in advance

Hi @Baby123

Go to → Activities Panel → Click on Filter → Select Show Modern.


Step 1 : Use Excel process scope followed by Use Excel file activities.

Step 2 : Use Format Cell Activity,

Check out the XAML file

FormatCellStudioX.xaml (8.5 KB)


Hi @Gokul001 ,

I saw the workflow but after changing the format I want triangle shape in the left corner of the cell .

Please find the attachment below.


After changing the cell format as text I want to triangle shape also in each cell


Here one option is to use the Format cell activity. Another approach is , if your template is static, then you can create a Sample Excel Template with all the custom formats for each columns.

Then you can use Read range and write range to that particular template. I hope it can preserve the formats as required.