View Single Post
  #3   Report Post  
Shatin
 
Posts: n/a
Default

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