How to format cell into Thousands based for numeric data???

[Guest]

Hi,

I would like to format the cell into Thousands based for numeric entry;
which mean when i entred 125 / 369 into a cell, the number(s) should appear
as 125,000 / 369,000. I've tried out using the Format > Cell... option, by
entering the format as ###,000 into the Custom text box. But it seems like
not going to work out as what expected.

So anyone out there can help???
Thanking in advanced.

 

[David Biddulph]

Tools/ Options/ Edit/ Fixed decimal places: -3

But that would apply to everything, not just to one cell.

 

[Guest]

Thanks for your solution!
It's working now.............. : )