nmedeiros
Scholar

Get List Action- Values converting when imported

Hi—I am trying to import an excel file that contains a column with time value onto RPA, but when loaded on RPA it is converted into decimal.  I have attempted to change formatting on excel column but have not had any success with getting correct values to upload on to RPA.  I have tried both csv and xls file types.

Labels: (1)
0 Kudos
Reply
2 Replies
MillaZ
Community Manager
Community Manager

Re: Get List Action- Values converting when imported

@michta Could you please try and assist here?

0 Kudos
Reply
WillD
Scholar

Re: Get List Action- Values converting when imported

I'm may have a couple of solutions to your problem.

In the Excel file create a new column that is formatted as Text.

Place this formula in the cell to use the corresponding cell and populate it with the text value of the time.   The 'A2' is the address of the cell with the time value that column B will populate the cell associated with the formula, in this case 2, with that value as text.

B2 =TEXT(A2,"hh:mm:ss AM/PM")

WillD_2-1647979234105.png

 

The second method is to save the file as a CSV '(Comma delimited) (*csv)' then when importing to change the Data type to Text not Date.

WillD_3-1647979532524.png

WillD_4-1647979655714.png

WillD_5-1647979726273.png

WillD_6-1647979835162.png

WillD_8-1647979908554.png

WillD_9-1647980025683.png

 

This will import the data into RPA with the Time as Text in the format you want.

I hope this helps.

 

 

Reply