How can I format number into thousand?

I have a forecast file in complete numbers, for example $2,000,000;
$15,400,000, etc. How can I format the number into $2,000; $15,400
without manually divide the number by 1000?

Thanks,
Roni

Roni,

Try a custom format of

#,##0.0,

--
HTH

Bob Phillips

"Roni" <[email protected]> wrote in message
news:[email protected]...
> I have a forecast file in complete numbers, for example $2,000,000;
> $15,400,000, etc. How can I format the number into $2,000; $15,400
> without manually divide the number by 1000?
>
> Thanks,
> Roni
>

Format > Cells > Custom:

$#,###,

"Roni" <[email protected]> wrote in message
news:[email protected]...
> I have a forecast file in complete numbers, for example $2,000,000;
> $15,400,000, etc. How can I format the number into $2,000; $15,400
> without manually divide the number by 1000?
>
> Thanks,
> Roni
>