Reading Excel without changing the format

Help
1

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

2

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

(Note: N0 → N followed by Zero)

3

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
4

Thanks, its worked

5

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