Hi Rohit,

eg in cell A1, if i enter 1000,000 then the outcome should be 1,000.

Use a custom number format.
More number formats, then select Custom, then enter
#,##0,
including the trailing comma.

Ed Ferrero
www.edferrero.com