Convert column in Excel to dd/MM/yyyy

Help Studio
, ,
1

I’m not able to convert the column date to dd/MM/yyyy completely in Excel, I need help!

A screenshot of Excel displaying a table with dates in column B formatted as "dd/MM/yyyy," alongside the "Format Cells" dialog box showing the custom date format settings. (Captioned by AI)
A screenshot of Excel displaying a table with dates in column B formatted as "dd/MM/yyyy," alongside the "Format Cells" dialog box showing the custom date format settings. (Captioned by AI)1063×585 34.3 KB

2

@Richarlei_Reis

The datetime would be taken as your locale format and then gets converted

So while writing to excel as well you have to take care to write in the same format as your locale to make it understand when you use a format cell

Cheers

3

It’s not converting, it’s just changing the Layout, can you help me?
DateFormat.zip (115.8 KB)

4

Hi @Richarlei_Reis

try this ,
row(“Date”) = DateTime.Parse(row(“Date”).ToString).ToString(“dd/MM/yyyy”)

Happy Automation!

5

Hey @Richarlei_Reis first read the excel using read range save as dt(datatable) now using for each row inside for each use 1 assign activity
Of string variable and pass the method

DateTime.ParseExact(“01/02/2025”, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

So it will convert your date .

Cheers

6

Hey, the easiest way out would be to change all the column types in the above excel
to text , instead of the Excel
identifying the column to be as a date. once the columns are set to text , the data should be there in the original
format .

Let me know how it goes :wink:

7

Hi @Richarlei_Reis

Try to give the format in below way, it should work.

The image shows a Microsoft Excel automation task focused on formatting cells in the "Lancamentos" sheet, specifically in column B, with a custom date format of "dd/MM/yyyy". (Captioned by AI)
The image shows a Microsoft Excel automation task focused on formatting cells in the "Lancamentos" sheet, specifically in column B, with a custom date format of "dd/MM/yyyy". (Captioned by AI)905×427 18 KB

Hope it helps!!

1 Like
8

Thanks it helps to format cells value.