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

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.

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.

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

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


"David Biddulph" wrote:

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.