How to Convert time to text string in excel?


i have a column that contains date time in format “dd MM yyyy HH mm ss” and ‘custom’ format. I need to convert it to text. In excel it can be done with TEXT function:

=TEXT(A1;“dd MM yyyy HH mm ss”)

how can i do it with uipath ?

read data from each row of your excel from that particular column and store it in a variable. Then you can use YourDateTimeVariable.ToString() and write it back to same cell use write cell activity

1 Like

Hi @Welcoming

Use read cell and strore in a particular variable (lets assume strText)

In assign activity
strText = cdate(strText).tostring(“dd MM yyyy HH mm ss”)

Instead of 12-11-2020 pass the variable strText


Hi @Welcoming

In addition to what @Surya_Narayana_Korivipadu said tick the preserve format range while reading the excel file

@NIVED_NAMBIAR @prasath_S @Surya_Narayana_Korivipadu


The robot extracts ‘0.625’ and in the excel file it says “15:00” …

can you show the excel file data and the xaml to get the clearer picture

I am just using ‘read cell’ and when i store it in a variable, when using a log message it writes ‘0.625’ for 15:00

could you please send the excel file and xaml file you are using because in my end it is working fine

have a look here:


Check below for your reference

Hope this may help you