Hi Team, I have following value 120000000.00 and I want this value suppose to show as per following number format. Input value : 120000000.00 Expected number format : 1200,00,000.00 Kindly assist me.

Hi @kawalkarhemant , Here I have attached the file to fix your situation. File : NumberFormat.zip (2.3 KB) Note : You can define your custom format. I have used the “en-US”. But if you want , you can change your own culture and specify the separators for grouping and decimal. [image] Regards …

I am looking for number format as per following 1200,00,000.00

Help

sreekanth (sreekanth) April 13, 2018, 12:35pm 9

@kawalkarhemant I went through the link provided by Dominic.Your format is same as the solution provided in link

1 Like

Change amount column values in excel to standard format of 1,234,567.89

Topic		Replies	Views
How to convert String Datatype value in Comma separated value? Help studio , variable	5	7508	October 29, 2018
Number format issue Help activities , studio	30	7131	October 29, 2018
How to add comma to the integer value Studio studio , question , activities_panel	9	2309	March 9, 2023
How to Convert string 1234567890 to 123,45,67,890.00 this format Studio excel , studio , string	5	1055	January 13, 2023
Double values Something Else datatable , excel , feedback	10	913	October 20, 2022

Most Active Users - Yesterday
Anil_G
ashokkarale
kouhei_yamaguchi
ppr
Nabin_Timalsina
sharazkm32
banksmegacorp
alexis.mendoza.rpa
m.takamiya
Honda
More details...

I am looking for number format as per following 1200,00,000.00

Related topics