Hi Ebrim
First, select the cells to be formatted, then choose Format, Cells. Click the Number tab. Select Custom from the Category list, and in the Type box enter 0, (that's a zero followed by a comma).
When this number format is applied, the cells will retain the correct numerical values, but they will be displayed without the last three digits.
To display values in millions, insert an additional comma at the end of the format string (0,,).
Another possibility is to display one or more decimal places--for example, 52,100 as 52.1. To do this, include a decimal point in your format string (0.0,).
RegardsKush
EBRIM SAWANEH wrote:
DEAR ALL,I NEED YOU HELP ON THE EXCELI HAVE A EXCEL REPORT WHICH THE FIGURES ARE IN E.G 1,000,000HOWEVER, I NEED THEM IN THOUSAND...... . IT IS LOT OF FINANCIAL STATEMENT. IT LOT TO DO ONE BY ONE.ANY MEAN IN TERM OF FORMATINGPLEASE HELP
MANSA 4 ALL (E.B )
PROUD OF YOU
----- Original Message ----
From: "ACCA_Profs@yahoogroups. com" <ACCA_Profs@yahoogro ups.com>
To: ACCA_Profs@yahoogroups.com
Sent: Friday, November 30, 2007 7:47:20 AM
Subject: [ACCA_Profs] New file uploaded to ACCA_Profs
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the ACCA_Profs
group.
File : /Journals,Newslette rs,Articles/ whytaxesmatter. pdf
Uploaded by : mustafakarimpk <mustafakarimpk@ yahoo.com>
Description : why taxes matter a great ebook on the issue
You can access this file at the URL:
http://groups. yahoo.com/ group/ACCA_ Profs/files/ Journals% 2CNewsletters% 2CArticles/ whytaxesmatter. pdf
To learn more about file sharing for your group, please visit:
http://help. yahoo.com/ help/us/groups/ files
Regards,
mustafakarimpk <mustafakarimpk@ yahoo.com>
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
Earn your degree in as few as 2 years - Advance your career with an AS, BS, MS degree - College-Finder.net.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___








0 comments:
Post a Comment