Write range activity is writing data in cells in Scientific form (6.295...E+12)

Sami_Rajput · January 25, 2024, 5:14am

How can i avoid writing in this format

Thanks!

pravallikapaluri · January 25, 2024, 5:16am

Try this

Anil_G · January 25, 2024, 5:16am

Use format cells and format the cell to text and check

Cheers

mkankatala · January 25, 2024, 5:17am

Use Autofit activity.

Hope it helps!!

lrtetala · January 25, 2024, 5:17am

Try this

Input:

Output:

Regards,

Yoichi · January 25, 2024, 5:24am

Hi,

Can you try to set text format using FormatCells activity in advance, then writer range?

Regards,

Sami_Rajput · January 25, 2024, 6:06am

Thankyou so much everyone!

system · January 28, 2024, 6:06am

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

Topic		Replies	Views
Write cell - problem with formating Studio uiautomation	3	790	July 8, 2022
How to define a specific data type when generating an Excel Studio uiautomation	1	771	March 4, 2022
Write Range :Could not write the data table DataTable starting staring with A1 Activities excel , uiautomation , activities , studio	7	1516	June 8, 2022
Write Range activity doesn't work well Help	3	1120	August 31, 2019
Different Type Result In excel Write range Activities excel , uiautomation , activities , studio , question	5	285	October 9, 2023