0:01
hey everyone welcome back to Exel wi
0:04
today we are diving into another Super
0:06
exciting trick how to convert numbers
0:09
into words in Excel whether you're
0:11
working on invoices Financial reports or
0:14
just want to save time this method will
0:16
make your work much easier stick around
0:19
as I show you step by step how you can
0:22
get this done let's get
0:25
started to convert numbers into words in
0:28
Excel the first step that you need to do
0:30
is to activate your developer
0:33
tab for this Excel sheet that I'm
0:37
currently using it's activated but if
0:40
you've not done so this is how you can
0:42
do it right click anywhere on your
0:45
Ribbon click on customize the
0:49
ribbon and then under on the left click
0:52
on customize the ribbon on your right
0:55
under the main tabs uh check the
0:58
developer box on my sheet at the moment
1:01
it's checked on because we had it
1:04
already but for you you'll have it to do
1:06
it uh for the first time click okay once
1:11
that's done uh go back to your developer
1:15
tab on your left click on Visual
1:18
Basic once you're on Visual Basic you'll
1:27
insert click on insert and choose
1:32
module once you have this popup go back
1:37
Google and look for spell number code
1:41
you will find a lot of them so choose
1:44
one that you feel comfortable using I
1:47
had one already copied so I'll copy it
1:50
once more and paste here click on alt
1:54
plus Q to go back to your Excel sheet
1:58
and this time round start typing your
2:00
formula equals spell spell
2:03
number and then choose your
2:06
tab sorry choose your cell close your
2:10
parenthesis and hit enter as you can see
2:13
the amount on the First Column is 10 and
2:16
the amount in words is 10 you can do the
2:19
same for every uh row or every cell but
2:24
in this case you you've done the first
2:26
one you can apply to the rest of them by
2:32
and dragging down so you've got
2:37
25.5 5 100 200 500 1,000 like that so
2:44
this is how you convert numbers into
2:48
Exel and if you have any more questions
2:51
please feel free to leave a comment down
2:54
in the comment section subscribe if
2:57
you've not and I look forward to seeing
2:59
you next in the next video
