How to format cell into Thousands based for numeric data???
Tools/ Options/ Edit/ Fixed decimal places: -3
But that would apply to everything, not just to one cell.
--
David Biddulph
"Jac" wrote in message
...
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.
|