Hello! I want to convert my number, which i get after I use a formula, to date format. The date should be written as dd.MM.yyyy [image] Thanks.

TestV2.xaml (18.4 KB) here it is, it will loop through all the values within the excel and it will write the values to AD2

Change Format in Excel (General to Date)

HareeshMR (Hareesh Madasi) July 18, 2019, 11:16am 13

Mention Toshortdatestring in the place of tostring(format)

1 Like

Formatting date column

Topic		Replies	Views
How to properly convert Date from excel to String? Activities excel , activities , question	4	3021	October 15, 2021
Date formatting problem Help studio	3	811	January 16, 2021
How to fix date column in excel? Studio excel , question	6	2156	March 23, 2020
Convert excel general format to date type issue Help excel , activities , question , data_manipulation	5	1539	January 13, 2020
Date Format from Excel Converter Activities excel , activities , question	8	429	July 13, 2023