Excel format _ retain format


#1

hi all,
i am reading a column from excel which is number and values are 22,000 ( with a comma)…

when i write to a different excel the comma is not there.

how do i retain it?

i am not using a buidtable


#2

@dennis Usually excel column are General format, so ur not getting commas, so change type of column in excel to accounting or number type and edit that type according to ur requirement. That will work for you. There may be other methods also but above will work for you


#3

change type of column in excel means ?- before reading into uipath ?

  • can this be done within uipath ?? - if so how

#4

@dennis u have to do it manually.