How I extract cell value as it is which is double

I want to extract B9 cell…which holds value 2,771.66 . I also want this “,” into that number
My result is shown 2771.66 output…but I want 2,771.66 .


In read cell activity we have an option called PRESERVE FORMAT

Enable that property and give a try

Or if you are using read range we got that same Option there as well
Enable in that and check the output

Cheers @rutuja.y

Numeric datatypes don’t have commas in them. They’re numeric values. Whether there is a comma or not is up to you when you output the numeric value as a string.

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