My string is getting converted to numbers


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


You can use Preserve Format option in Read Range activity

Hope this may help you


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

Hi @mukesh_behera,

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


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

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

Hi @mukesh_behera,

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