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

J

Jac

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.
 
D

David Biddulph

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

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