Converting Numbers to Words using Excel 2007
There is no provision or tool available in excel 2007 for converting Numbers to words. This is possible only with the VBA code. But with the combination of some simple available formulae in excel 2007, it is possible to create a tool for converting Numbers to words without any complicated coding. This process needs creation of some table of contents having some regular excel formulae. This table can be kept invisible by keeping it in separate worksheet and hiding it. Only result can be used in your working sheet. The table which is to be created will be as shown below.
Let us go to step by step procedure how to create it.
Create a table as shown below. You have to enter direct values in Red colour cells. No formulae are existing in Red colour cells. But all Green colour cells are having specific formulae in it. In the extreme left side, values from 1 to 17 are visible, but you have to create it up to 99. Enter the formulae in the corresponding Green cells from the below given formulae.
Cell–E18 : =IF(H15=0,”",VLOOKUP(H15,$B$2:$C$101,2))
Cell—E16: =IF(G9=0,”",VLOOKUP(G9,$B$2:$C$101,2)&” Hundred “)
Cell—E15: =IF(G10=0,”",VLOOKUP(G10,$B$2:$C$101,2)&” Thousand “)
Cell—E14: =IF(G11=0,”",VLOOKUP(G11,$B$2:$C$101,2)&” Lakh “)
Cell—E13: =IF(G12=0,”",VLOOKUP(G12,$B$2:$C$101,2)&” Crore “)
Finally in the answer cell i.e in F4 the formula will be
Try to create formula by using above simple combination of formulae. The result can be as shown below.
In this case, the created table is in another hidden work sheet. Only links have been given to that formula.
Try it.If you are unable to get it, Click Here to download a developed table .