Sunday, June 26, 2011

(VU-Study-Corner) Very Very Excellent function of Excel for Accounts & Banking Students

Convert digits into words using excel

You type = 4556
Excel types= Four thousand five hundred fifty six only

Follow these steps


1- Open attached file
2- Go to tools menu
3- Go to Macro
4- Click security
5- Set security level to Low
6- Save it
7- Close file
8- Open it again
9- Enter value in green area and see the result


To find how u can do this urself contact me at 

--
Join us at facebook: https://www.facebook.com/VU.Study.Corner
 
Group Link: http://groups.google.com/group/VU-Study-Corner?hl=en
 
Group Rules: http://groups.google.com/group/VU-Study-Corner/web/group-rules
 
Unsubscribe: VU-Study-Corner+unsubscribe@googlegroups.com
 
Adult contents, Spamming, Immoral & Rudish talk, Cell number, Websites & Groups links specially in paper days are strictly prohibited and banned in group.

No comments:

Post a Comment