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
>