Change format excel?

[fairymemay (noona)]

I want to change format in column FPP (Use Column Name) to number.

From

To

Please guide me for solve it.

[Gokul001 (Gokul Balaji)]

Hi @fairymemay

Have a look on the document

Change format of Excel sheet Columns to Text UiPath - RPA Learners

Refer this thread

Change format column from "General" to "Date"

@LZlz - here you go… ConvertOADate_LZ.xaml (5.8 KB) Output: Test_LZ.xlsx (9.0 KB) Hope this helps… Note: When you are running the real file, you have to make sure you don’t have any blank values in that column. or else the conversion will fail. If you have blank values in the column then you have to filter that out first and then pass that to the invoke code…

Regards
Gokul

[fairymemay (noona)]

@Gokul001 i don’t want select column by ALPHABET but I want fix with column Name.

Please guide me for solve it.

[PrankurJoshi]

Hi @fairymemay

You can try invoking a VBA.

see this post

How to change the whole excel sheet columns data type to text

Hi I want to change the data type of the whole excel sheet into text. Can any one guide

Thanks,
Prankur

[fairymemay (noona)]

@PrankurJoshi From your suggest it use Range B1:B20.

But I don’t fix column B ( I want use column Name(header name))

please guide me for edit it.

[nikhil.girish]

Hi @fairymemay

Change entire column datatype

Hi, Here is the activity Change Column DataType for multiple column. Video demo : [UiPath datatable aggregation| change data type of data table| group by] Thank you Balamurugan.S

try this above activity , this will help you

Thanks