Excel format cells

Hi, Team!
I have an excel file with multiple columns.

I use read range activity and I get DTexcel output.
I use the assign activity
selectedColumnsDT = DTexcel.DefaultView.ToTable (false DTexcel.Columns (“QTY”). ColumnName, DTexcel.Columns (“Price”). ColumnName)
I use the write range activity to write the information I need (the one stored in selectedColumnsDT), in another excellent file … but on the QTY column, instead of 1.950, it writes me 1.95, and instead of 1.650, write 1.65.

Can you help me with a tip?

Thank you in advance!

The type of the cells to be kept as text.


How to do that?

Thank you!

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