Reading Excel without changing the format

Hi Team,

I need to read column B and column C without changing the format.
here how it looks

after reading I need to pass 50,000 and 250,000 first time…and next go for the 2nd value.
I need 50,000 not 50000.


Try this convert.ToDecimal(row(“ColumnName”)).ToString(“N0”)

(Note: N0 -> N followed by Zero)

while using the read range activity did you try to use the property
retain property? or choose value type as text, this will not change the format.


Thanks, its worked

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