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" 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 |
All times are GMT +1. The time now is 09:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com