Tuesday, December 21, 2010

{http://www.kavyatarang.co.cc/} CONVERT FIGURE TO WORD EXCEL AND EXCEL SHORT CUTS

CONVERT FIGURE TO WORD EXCEL AND EXCEL SHORT CUTS

 

In day to day use of excel,in many files we convert figures in words as its a requirement for many institutions to show all the important figures into words also .While converting some times ,some errors are inevitable and sometimes these small errors may becomes the reason for loss of thousands ,due to rejection of tender or project reports.so every body things that there may be some command in excel which they does not know ,but as far as my knowledge is concerned ,there is no such command in excel as such ,by which this Job can be done.However we can do this Job by installing a small excel add in file in excel .Yes we can do this.I am doing this from last three four years,so I think I should also share this with you also .I know that many of my friends may have this utility ,but I hope this utility still helpful for many.

How to use

1.download "
convert figure into word excel
 
" (for this file find attachment) from here and UNZIP IT and save the word.xla file in hard disk
2. save it in a Folder permanently. (do not change the location of file after installation)
3. Now open excel Goto Tools>add in >browse (browse the file where you have stored the downloaded the file and select the file)
4 press ok
that's all

Now to convert a figure in to words type in formula bar
=word (cell number in which figure are given)

suppose figures are given in A2 then command should be =word(A2)
that's all

You require
Win 95/98/NT/2000/ XP, MS Excel 97/2000

Further Few Excel short cuts are also given below for your ready reference .
(DOWNLOAD EXCEL SHORT CUTS)
 




--
--
Animated-Walking-Monkey-Happy-New-Year-2011-Champagne-Bottle-01.gif
newyearglitter21.gif
सुखाच्या मागे धावून धावून,
मन आयुष्‍याला विटते,
आणि तेव्‍हां कुठे त्‍याला,
मृगजळ भेटते.........
प्रशांत पवार
gmail.php.png





No comments:

Post a Comment

Note: Only a member of this blog may post a comment.