How to keep the text format

variables
excel
bug
fixed

#1

Dear all,
meet one problem, very simple example, use RPA express copy A column to B column,
A column:


RPA Recording:

the result B column:

questions:
why B column add .0 text? how to keep the text format as original?

Best regards!


#2

anyone give advice?


#3

Hi @xuzfAQbeOcamOx it is a bug we have in excel. We have it on the list of issues to be fixed.
You can use text actions or number format action to trim the additional characters.


#4

@ashapkina millions thanks!


#5

This has been fixed in RPA express 2.2.