Convert Numbers to Words using Indian Numbering in Google Sheets | Google sheet formulas |

preview_player
Показать описание
In this video explained how to Make & use Number to word conversion in Google sheet when we are generating Delivery Challan, Invoice, Purchase orders, Bills. Etc. We are bringing Google sheets Tutorials for all.

To get started, go to your Google Sheet, click the Tools menu and select Script Editor. Copy-paste the function below inside the Script Editor and chose File then Save to save your changes.

Now switch to the Google Sheet, type =Ntow(123) in any cell and it will instantly spell the number in words using the lakhs and crores system.

my another video is :
Date Difference function on Query :

Google sheets vs Excel (Spreadsheets ka king kaun ? ) :

Hi, This is Fyi Nonstop, which brings videos for use in real life in office Or Personal Financial or Health Etc. requirements or which you need to know.

"script copy from below file shared line :

My Playlists :

Stay Connected with us :
Рекомендации по теме
Комментарии
Автор

lots of video i trying, but finally your coding is worked, Thank You so much. :)

MS_self
Автор

Still it is not giving amount in paisa like rupees 112.45 it is giving only (Rupee one hundred twelve only)

pritirajvanshi
Автор

does not return value for paisa. This given value for whole number
Not useful

MayankGoyal