Please note , my input number vary every time , still it work?
ex. sometime input is 12111.50 then expected 12,111.50
sometimes it is 121111.50 then expected 121,111.50
input is coming in same variable
Please note , my input number vary every time , still it work?
ex. sometime input is 12111.50 then expected 12,111.50
sometimes it is 121111.50 then expected 121,111.50
input is coming in same variable
In this case you can use the Double Formater as below with example
File : Form1.zip (1.7 KB)
OutPut:
Regards
Balamurugan.S
But method given above (mine) works perfectly without conditioning…
is there way to handle this situation…
Consider i am reading amount from excel file…each time it would be different.
if Amount=12111 then my formatted string will be 12,111
and next time if Amount =121111 then it will be 121,111