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
image

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.

Thanks

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.

4 Likes

Thanks, its worked

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