How can I format number into thousand?

Roni · 10-09-2005, 10:05 AM

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

Bob Phillips · 10-09-2005, 11:05 AM

Roni,

Try a custom format of

#,##0.0,

--
HTH

Bob Phillips

"Roni" <setiawanroni@yahoo.com> wrote in message
news:1128865269.547435.115370@g49g2000cwa.googlegroups.com...
> 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
>

Shatin · 10-09-2005, 01:05 PM

Format > Cells > Custom:

$#,###,

"Roni" <setiawanroni@yahoo.com> wrote in message
news:1128865269.547435.115370@g49g2000cwa.googlegroups.com...
> 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
>