تفقيط الأرقام إلى حروف عربية في Google Sheets | تحويل أي رقم إلى كتابة عربية باستخدام Apps Script

Looking for a way to convert numbers to Arabic text in Google Sheets? In this lesson from eLearn School, we'll learn step-by-step how to create a custom function using Google Apps Script that converts any number into complete Arabic text within Google Sheets. Converting numbers to words is one of the most frequently used processes in electronic invoices, financial documents, and accounting reports, where users need to convert numbers into Arabic text written in words instead of displaying them as numbers only. In this video, we will learn: ✅ Downloading a library for spelling out Arabic numbers ✅ Copying the code and adding it to Google Apps Script ✅ Creating a custom function within Google Sheets ✅ Writing conditions to handle potential errors ✅ Adding a description to the custom function ✅ A practical experiment to convert numbers to Arabic letters Examples of results: 1 ← One 10 ← Ten 25 ← Twenty-five 100 ← One hundred 125 ← Twenty-five 1000 ← One thousand 10000 ← Ten thousand 125000 ← Twenty-five thousand 1,000,000 ← One million This function can be used in: ✔ Invoices ✔ Accounting systems ✔ Payroll ✔ Payment orders ✔ Checks ✔ Official documents ✔ Educational projects ✔ Google Workspace applications In the next video, we will learn how to spell out numbers with different currencies, such as: Egyptian Pound Saudi Riyal Saudi Riyal UAE Dirham Kuwaiti Dinar And many other currencies. 📌 Timeline: 00:00 Practical example of what the function will do 01:38 The number spelling library and copying the code 02:56 Creating the custom function to spell numbers 04:15 Writing conditions in the code to handle errors 05:48 How to make the code a custom function and write the description 07:56 Testing the custom function to spell numbers into Arabic letters If you liked the video, don't forget to subscribe to the eLearn School channel and activate the bell icon to receive all the latest updates about: Google Sheets Google Forms Google Apps Script Automation Web Apps Google Workspace Artificial Intelligence with Google Workspace Download link for the number spelling library code: https://cdn.jsdelivr.net/npm/tafqit/t... WhatsApp For Business Only: +201276102220 ► ► Contact number via WhatsApp for business inquiries only: 00201276102220 Telegram: ► https://t.me/e_Learn_School eLearn School channel on WhatsApp: https://whatsapp.com/channel/0029Va1E... ► Follow us on: ►TikTok:   / elearn_school   ►Telegram Channel: https://t.me/eLearn_School ►Telegram Group: https://t.me/joinchat/TJiA3BhpaIQbtug... Join our community: ►TikTok:   / elearn_school   ►Telegram Channel: https://t.me/eLearn_School ►Telegram Group: https://t.me/joinchat/TJiA3BhpaIQbtug... #GoogleSheets #NumberSpelling #NumberToWordConversion #GoogleSheets #eLearn_School #GoogleSpreadsheets #AppsScript #Accounting #NumberSpelling