Number format issue

@balupad14

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:

image

image

Regards
Balamurugan.S

1 Like

But method given above (mine) works perfectly without conditioning…

1 Like

@pllo2ptk
No…It is giving output as 1,20,000.00.

expected is 120,000.00

Hi @SagarSB,

I have edited my previous post with output.

Regards
Balamurugan.S

1 Like

@balupad14

But my input variable will be same always…only value can be different…

@balupad14

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

Hi @SagarSB

I have created a sample with dynamically change the value with datatable

File :Form2.zip (2.1 KB)

Regards
Balamurugan.S

2 Likes

@balupad14

I will it and let you know

@balupad14

Its working…
Thank you so much

1 Like