InfoPath Dev

Hi all, I have a text field, mainly it stores numbers like 5520000, 10000, etc. and i want to make these numbers in thousand format with commas like 5,520,000 or 10,000. Remember its a text field not number field and i don't want to change the field data type to number. so, help me how to achieve this. Thanks

No reply by all ?

You want the actual value to contain a comma? Or do you want it to just display with a comma?

I want actual value with comma. BR

I'm sure there are more elegant ways to do this, and there are a wide variety of ways my approach could go wrong (I'm not handling for people entering non-numeric data, for example, and this will only work on numbers up to quadrillions, but it should give you an idea. Save the attached file locally. Right click the file and select design. Then you can preview and give it a try.