How to display a number 122,789 become 122?
I want all number display up to thousand.
For example, 456 instead of 456,223.
Thanks

1. Type 1,000 in another cell.

2. Copy (Ctrl+C)

3. Select No.s;

4. Paste Especial (Alt+E and then S)

5. Select Divide in Operations section;

6. Hit Enter

"sh" wrote:

> How to display a number 122,789 become 122?
> I want all number display up to thousand.
> For example, 456 instead of 456,223.
> Thanks
>

You can also use, if you don't want to roundup, for a cell like A1=
=Rounddown(a1,0)/1000

"FARAZ QURESHI" wrote:

> 1. Type 1,000 in another cell.
>
> 2. Copy (Ctrl+C)
>
> 3. Select No.s;
>
> 4. Paste Especial (Alt+E and then S)
>
> 5. Select Divide in Operations section;
>
> 6. Hit Enter
>
> "sh" wrote:
>
> > How to display a number 122,789 become 122?
> > I want all number display up to thousand.
> > For example, 456 instead of 456,223.
> > Thanks
> >

Use a custom format of: #,

If your data can be in the millions, and you want to have a comma separator,
use: #,###,
--
Regards,
Fred


"sh" <(E-Mail Removed)> wrote in message
news076597A-31A2-4D2B-B1F7-(E-Mail Removed)...
> How to display a number 122,789 become 122?
> I want all number display up to thousand.
> For example, 456 instead of 456,223.
> Thanks
>