How to Convert Number into Khmer Number and Back in Excel (Khmer)
Learn how to convert number into Khmer number and back in Excel step by step with simple custom format, formulas, and Khmer video guide.
Hello everyone! Today I show you how to convert English number (1, 2, 3...) into Khmer number (១, ២, ៣...) and convert back in Excel step by step with easy custom format and video guide in Khmer language. Please check out the video below for more detail.
Convert between:
- English to Khmer:
1, 2, 3, 4, 5, 6, 7, 8, 9➔១, ២, ៣, ៤, ៥, ៦, ៧, ៨, ៩ - Khmer to English:
១, ២, ៣, ៤, ៥, ៦, ៧, ៨, ៩➔1, 2, 3, 4, 5, 6, 7, 8, 9
Method 1: Convert English Number to Khmer Number (Custom Format)
The easiest way to display Khmer numbers in Excel is using Custom Format.
Step by Step:
- Select your cells containing numbers (e.g.
12345). - Press
Ctrl+1on keyboard to open Format Cells dialog box. - Click on Number tab ➔ select Custom from category list on left.
- In Type input box, enter this format code:
(Or[$-km-KH,1200]0[$-km-KH,1200]#,##0if you want comma separators) - Click OK.
Now your number 12345 will show as ១២៣៤៥ instantly!
Method 2: Convert Khmer Number Back to English Number
If you formatted cells using Custom Format, converting back is super easy:
- Select cells formatted in Khmer numbers.
- Press
Ctrl+1to open Format Cells. - Choose General or Number category.
- Click OK.
Your Khmer numbers ១២៣៤៥ will immediately turn back into standard English numbers 12345!
📹 Watch Khmer Video Tutorial
Watch video step by step below to see how to convert Khmer numbers in Excel:
💡 Quick Tip:
- Using Custom Format (
[$-km-KH,1200]0) only changes how numbers look on screen. The actual cell value remains a real number, so formulas like=SUM(),=AVERAGE(), or calculations still work 100% perfectly!- If you type Khmer digits manually as text (e.g.
១២៣), Excel treats them as text strings, so math formulas won't calculate them directly. Always use Custom Format for best result!
📚 Related Resources
Related Tutorials
Opens in new tab ↗IF vs Equal (=) vs EXACT Function in Excel (Khmer)
Learn the difference between Equal (=) operator and EXACT function in Excel for case-sensitive text comparison step by step with Khmer video guide.
How to Calculate Working Hours in Excel (Khmer)
Learn how to calculate total working hours, subtract lunch break, handle night shifts, and calculate total pay in Excel step by step with Khmer video guide.
How to Split Decimal Number into Two Parts in Excel (Khmer)
Learn how to split decimal number into two parts (integer and decimal) in Excel step by step with simple formulas and Khmer video guide.