Type Into fields with thousands separator and two Decimel places

Hi!

I have a column on excel that is formatted into two decimal places and has a thousands separator. I would like this to be the same format when I use the Type Into Activity.

I have tried the below based on the pervious community questions. However it doesn’t work most of the time when the number on the excel sheet is 1,000.00 for example.

Any guidance on how to achieve this would be helpful.

Many thanks,
Mishal

while reading the data check the Preserve Format option and try

@MuralidharVankamaddi thanks for your response. where can I find the preserve format option?

I get the below options

No the Type Into Activity.

Excel activity like read range where you are reading the data from excel,

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