Scenario: downloading an Excel Sheet from mail, here in the excel the Column is set in Date format/general(User sends in different formats, eg: 07/27/2020,27-07-2020). then when trying to read the excel, how to convert that to exact format as dd-mm-yyyy.

Hi @Ashrita when using the above Cell Format activity, in one scenario im getting error .ie: If the Cell is already in Date Format(21/07/2020) and now again if im trying to change the cell format to “dd.mm.yyyy” then it is being converted to “21.00.2020” You have used the small “mm” for Month so…

Excel Date column/General column conversion to dd-mm-yyyy format

Learn Certification

balupad14 (Balamurugan) July 29, 2020, 9:42am 4

Hi @Ashrita,

Welcome to UiPath Community !

Here is an activity called “change cell type” . Using this activity that you can able to change cell type.

Video explanation :

Regards
Balamurugan.S

1 Like

Convert number text to number in excel and sum

Excel format transformation

Topic		Replies	Views
Date format is changed when writing the data in excel Help excel , studio , question	3	2200	July 3, 2020
Read Date from Excel Help excel	4	2661	September 18, 2019
Excel date format is changing from dd/MM/yyyy to MM/dd/yyyy Studio studio , question , activities_panel	11	1696	August 1, 2022
How to Convert a excel column to date time format Activities excel , activities , question	2	493	January 27, 2023
Date Format conversion issue in excel Activities excel , activities , question , vba , linq-query , invoke-vba	5	179	January 6, 2024

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Excel Date column/General column conversion to dd-mm-yyyy format

Related Topics