How do I set up a number to 1,23,459.00 formatting in excel?
 

I want to set the custom formatting to the above said format

How do I set up a number to 1,23,459.00 formatting in excel?
 

hi, Shiji !

I want to set the custom formatting to the above said format

you will 'see' the leading commas [but]...
you may want to give it a try: - #\,##\,##0.00

[perhaps] a 'better' way: - [=100000]#\,##\,##0.00;#,##0.00

hth,
hector.