HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How To Convert Currency To Words In Excel

32,343 views October 28, 2019 3:29

Watch on YouTube
ChannelExcel 10 tutorial

Description from the creator

$1.15 = One Dollar and Fifteen cents. This is what you are going to get.

Sometimes we gets rows of amounts where we need to write them in words and it becomes impossible to write a thousand rows of data in words. There is no built in function for this in excel. If you are having problem converting currency into words then you are at the right place. We are about to solve this for good. Lets follow the bellow steps to convert currency to words.
Step 1: Click on the Developer Tab (How to add developer tab in excel: youtu.be/jkSLYLk0OHU)
Step 2: Click on Visual Basic.
Step 3: Click Insert and than Module.
Step 4: Write the code (Please subscribe and here goes the code: msexceltutorial.com/post/How-to-Convert-Any-Cur…)
Step 5: Close the Visual basic window.
Step 6: Write the function in any empty cell =NumbersToWords(A1)
Step 7: Press enter and done.

**NOTES**
1: A1 is the cell number where you have the currency
2: If you need to convert different currency than leave a comment

#Convert #Currency
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $1
patreon.com/excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ

Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Excel VBA Programming Course: bit.ly/excelvbacourse

Social media:
Facebook: facebook.com/excel10tutorial
Twitter: twitter.com/excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: excel10tutorial.tumblr.com
Instagram: instagram.com/excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial *Become a member and enjoy exclusive perks while supporting the channel you love!*
youtube.com/@Excel10tutorial/join

About this tutorial

Excel 10 tutorial published this 3:29 video tutorial on October 28, 2019. It has been watched 32,343 times on YouTube.

Category
Education
Duration
3:29
Published
October 28, 2019
Views
32,343
Likes
118

Tags

Share

This tutorial in other languages