Skip to playerSkip to main content
Learn how to convert numbers into other languages.

How do I change the language of numbers in Excel?,
Can Excel automatically translate languages?,
How do I translate numbers in Excel?,
What is the formula to convert language in Excel?,

Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@jjnet247/shorts
https://www.tiktok.com/@exceltips247
https://www.instagram.com/exceltips247/
https://www.dailymotion.com/ExcelTips247
https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/
https://x.com/ExcelTips247/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Category

📚
Learning
Transcript
00:00I recently released a video demonstrating how to convert numbers into different languages.
00:04Following to this, I received a request to update my VBA code to support Russian character as well.
00:10For those who have downloaded the VBA source code from my community page, here's how you can do it.
00:15You're going to start off by pressing alternate F11 to launch your VBA editor.
00:19Over here, you're going to change from L to N.
00:22That's where the Russian characters are installed on my lookup table here.
00:26Again, if you like a copy of this VBA, please leave a request on the comment section and I'll show
00:30you how you can get this VBA function.
00:32Now press Ctrl S to save your VBA and then let's close my VBA editor.
00:36Let's have a quick peek into our language lookup sheet here.
00:39Like I mentioned before, you need to add a Russian translation in this lookup sheet here.
00:43It is in column N for me, which is number 12 column.
00:47And with all that being done, let's do a quick test here.
00:50You're going to say equal num lang sign at.
00:52And you're going to put the first argument as a number, comma, 12 is the Russian translation here.
00:58As you can see, it translates numbers into Russian characters.
01:02Let me know which language you'd like to see me do next.
01:04Please leave your request on the comment section below.

Recommended