Note that the custom format doesn't actually change the value/outcome
that's stored in the cell.
To actually change the value, one way is to choose Tools/Options/Edit
and change the Fixed decimal places input box to 3.
Note that this is a global setting and will affect all cells.
To change only A1, you could also use an event macro - post back if
you'd like to see that option.
In article ,
"Ed Ferrero" wrote:
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