My string is getting converted to numbers

Help Activities
1

Hello,

I am trying to read a column from excel as string and that column contains “#N/A” while i ma reading that as a string i am getting some numbers but I want that as it is, how I can do this.

Thank you in Advance

2

@mukesh_behera

You can use Preserve Format option in Read Range activity

Hope this may help you

Thanks

3

After checking the preserve format option read range activity not reading my excel at all. Any other idea to handle this?

4

Hi @mukesh_behera,

Is that number or number pattern is same for all #NA?

5

Yes.

6

Then you can replace that pattern or number with #N/A

7

Yes, that thing I can do but I was checking if we have some other procedure to get the symbol as it is.

8

Hi @mukesh_behera,

Preserve format is other option. If it not works then replace will be the easiest option.

Thanks.