Excel format cells

Hi, Team!
I have an excel file with multiple columns.
|QTY|PRICE|Value|
|1.950|0,505|984,75|
|1.650|0,505|833,25|

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.
|QTY|PRICE|Value|
|1.95|0,505|984,75|
|1.65|0,505|833,25|

Can you help me with a tip?

Thank you in advance!

The type of the cells to be kept as text.

2 Likes

How to do that?

Worked!
Thank you!

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