I am trying to take DOB value from Excel sheet to Web page.
Using Type into Activity in the Text as .Tostring.
But on the Web page it is giving me some random number instead of date.
How to get the date value as is to Web page.
A simple trick is to ensure that you check the property “PreserveFormat” when reading data from excel. (See yellow mark in the image below)
This way UiPath will read the string/number as is in the excel sheet without changing formats. This is very useful function of Read range and other read activities like Read PDF text etc.