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 .
Hi
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.