Integer value from excel to another Excel cell generates different value

Help Studio
, ,
1

I have to write integer value to another excel sheet

input Excel:

image
image745×75 3.72 KB

But when write another excel Getting output like:

image

Thanks
Shaik

2

Hi @shaik.muktharvalli1

Use format cells activity

The image shows a UiPath workflow for processing an Excel file, focusing on setting the number format for a cell range in "Res.xlsx" with 0 decimals. (Captioned by AI)
The image shows a UiPath workflow for processing an Excel file, focusing on setting the number format for a cell range in "Res.xlsx" with 0 decimals. (Captioned by AI)955×669 31.3 KB

Output

image

3

Hi @shaik.muktharvalli1

In Read Range workbook activity enable preserve format option

Regards,

4

Thank you @lrtetala it’s working fine

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.