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" wrote in message
oups.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

Format Cells Custom:

$#,###,

"Roni" wrote in message
oups.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