hello everyone and welcome back to our channel the teacher and in this tutorial
we will talk about how to convert numbers to words in excel worksheet
however excel doesn't have a default function that display numbers as in
this worksheet but you can use a visualization module to convert your
numbers to this word so that is what we are going to learn in this tutorial so
let's get started and here we have this excel worksheet monthly family budget
and we also have another worksheet here that is an invoice and here I want to
display the numerical value as what as you can see here we have amount here and
I want to display this total amount thirty one thousand two hundred forty
six one three nine Pesos so here I want to display that value in so here we have
two websites and I have given the link of these websites into the video
description you can go and check it out and if I scroll it down then you can see
that it has shown the full procedure of adding a VBA module to your excel
worksheet so it may convert your numbers to words so here we have that code that
you need to paste into the VBA module and we can click on copy this module and
then later we will paste that into excel worksheet so I am going to right click
and copy and I have also saved these codes into notepad files as you can see
here we have three notepad files here number to word for dollar and numbers to
word for Indian Rupees and that's what I will show you why we have this third
file here and I will show you two procedures of converting numbers to
words in dollars and in Indian Rupees because both of these currencies have a different separate code so basically this code is for
converting the numbers to words in dollars and as I live in India and we
use Indian currency Rupees and for that I need a separate code and here we have
another website where you can find that code to convert your numbers to words in
Indian currency and that is the code and here you can click that link to copy and
paste this entire code into a VBA module so first I will show you the Indian
Rupees method and for that I will select this entire code right click copy and now
I will move back to Excel and in this inverse worksheet and here I want to
display that value in words so here I will press alt plus F11 key to open the
VBA and here I will click on the insert menu and then we'll choose module we'll
maximize this window and now I will copy this entire module into the VBA module
section by right clicking and choose paste so this code has been modified
specifically for Indian currency because we have a different separator as compared to dollar and I will explain you that now we have this module now you
can press alt Q to save and quit back to the Microsoft Excel you can also close
this window right from here now after inserting the module what you will get
you will get a new function by pressing equal now if you will start typing spell
then here we have spell Indian module you can press the tab key to complete
this name here and as you can see that the parentheses has also given
automatically now which value you want to see as word in this cell so I want to
see the value of B25 this one into this cell B24 now I will close the
parentheses as soon as you will press the enter key you will see the value in
words 31,246 and 39 paisa so now if we move back to the Sony budget planner and
here I want to convert these values into words but in dollars so again I will
press the Alt plus F11 key and now I will insert a new module from the
insert menu and will copy and paste and will copy and paste this code into the module and that code is specifically for
dollar currency right click copy move back to the module and right click paste
Alt plus Q to save and quit so here in this worksheet if I start typing the
function equal to spell then the name is spell number not spell Indian so both of
these worksheet have different function name and here which value I want to convert
into numbers that is H5 let it close now I can copy this formula below to have
the values in words so here you can see that the value is 4000 and it display
that value in words as 4000 dollars and no cent so you can also modify the code
by yourself if you know how to use VGA otherwise I would like to show you one
thing that if you don't require that no cent value in the end then you can go
to the module again by pressing the Alt plus F11 key and where you can see the
entire script and where is the separator thousand, billion, trillion and trillion and below if you scroll down then you can see the cent values here as
you can see here in the inverted comma and no cent so if you don't want to
display anything if there is no cent then you can just use the inverted comma
begin and inverted comma close while having a space between them and for one
cent and for one cent I want to display and one cent value in the end as words
and if there are more than one cent then it should display the value as cent so I
just want to modify this one if there is no cent then it should display nothing
so let's see if it has modified the value as you can see here 4000 dollars
and no cent now if I again type the same function here style number equal to h5
bracket close now you can see that it has removed the no cent value so if you
look into this invoice worksheet then you can see that it is showing the value
in words perfectly like we have here one Arab 25 crores 44 lakhs 40 thousand four
hundred thirteen and 62 Pesos keep in mind that when you copy and paste the
module into the worksheet then it will only work in this worksheet if you open
a new worksheet then both of these modules will not be available here like
equal to spell as you can see that it is not suggesting anything here right now
because the module that you insert in VBA only work for that particular
worksheet you can also change the currency format in a particular worksheet by moving to more number formats and then here under currency if
you click the symbol list then you will find a lot of symbols for different
countries and I will go with the dollars now hit the ok key now only the symbol
has changed the value will still remain in rupees because of the module you
so what is the difference between both module which code has been changed to
convert the currency into rupees while typing as in words so I will show you
that also so here if I open this folder then here I have three files number two
word in dollar and here you can see the module name spell number and if I open
this one the name is tagging game so if I open Microsoft words and here if I
open a new file and go to the review tab and here I click on compare and under
original document I choose this one you number two word in dollar hit the ok key and under the white document I will choose
this one Indian rupees because so here in this file the code has been changed a
little bit like for billions we are like for billions we are using Arab and for
billions we are using crores and for millions we are using lakhs and rest is
the same thousand and hundreds so if I compare the dollar file with this one
Indian rupees and hit the ok key then you can see the difference between the
code as we have both of these files with a comparing chart here like you can see
all the three files here one is the dollar one is the rupees and then the
comparison so here you can see that the name has been changed from spell number
to spell Indian and then from dollars and cents to rupees and cents so that way the
person has changed the code to be compatible with the Indian currency so I
hope you will like this tutorial let me know by liking sharing and commenting on
this video and do subscribe to our channel for more upcoming tutorial videos
thanks a lot for watching bye and take care