របៀបកំណត់កាលបរិច្ឆេទជាភាសាខ្មែរក្នុង Excel - How to Use Advanced Khmer Date Format in Excel (Video in Khmer)

Hello everyone! In today's video tutorial, you will learn how to convert standard Excel dates into full Khmer date format step-by-step (e.g., ថ្ងៃចន្ទ ទី១៥ ខែមេសា ឆ្នាំ២០២៦).

Whether you are preparing official letters, administrative contracts, or monthly reports in Cambodia, using native Khmer date formats makes your documents look professional!

🛠️ Method 1: Using Custom Cell Formatting (Ctrl + 1)

1. Select the cells containing your dates.
2. Press Ctrl + 1 (or Right-Click ➔ Format Cells).
3. Under the Number tab, click Custom at the bottom of the Category list.
4. In the Type box, paste one of the custom Khmer date codes below and click OK:

Standard Khmer Date Format Code:

[$-km-KH,1200]dddd ទីdd ខែmmmm ឆ្នាំyyyy

or

[$-km,1200]dddd ទីdd ខែmmmm ឆ្នាំyyyy

Alternative Khmer Locale Format Code:

[$-1200453]dddd ទីdd ខែmmmm ឆ្នាំyyyy

Official Document Prefix Format Code (e.g. "ធ្វើនៅភ្នំពេញ..."):

[$-km,1200]ធ្វើនៅភ្នំពេញ dddd ទីdd ខែmmmm ឆ្នាំyyyy

📚 Related Tutorial: Want to extract day, month, or year from dates? Check out How to Use DAY, MONTH, and YEAR in Excel!

🛠️ Method 2: Convert Date using TEXT() Formula

If you want to join Khmer dates directly with text strings inside formulas, wrap your date cell with the TEXT() function:

=TEXT(A2, "[$-km-KH,1200]dddd ទីdd ខែmmmm ឆ្នាំyyyy")

Example (Official Letter Header):

="ធ្វើនៅភ្នំពេញ " & TEXT(TODAY(), "[$-km-KH,1200]dddd ទីdd ខែmmmm ឆ្នាំyyyy")

Output: ធ្វើនៅភ្នំពេញ ថ្ងៃចន្ទ ទី៣១ ខែសីហា ឆ្នាំ២០២៦

💡 Pro Tips

1. What Does 1200 Mean?: The LCID code 1200 instructs Excel to translate numbers and month names into Khmer script automatically (១, ២, ៣ and មករា, កុម្ភៈ, មីនា).
2. Date Code Breakdown:
   • dddd = Full weekday name in Khmer (ថ្ងៃចន្ទ)
   • dd = 2-digit day number (ទី០៥)
   • mmmm = Full Khmer month name (ខែមេសា)
   • yyyy = 4-digit year in Khmer digits (ឆ្នាំ២០២៦)
3. Dynamic Today Date: Use TODAY() inside the TEXT() formula so official letter dates update automatically every time you open the document!

📚 Related Tutorials

• How to Use DAY, MONTH, and YEAR in Excel
• How to Use WEEKDAY Function in Excel
• How to Use WEEKNUM Formula in Excel
• How to Use NOW() and TODAY() in Excel
• Learn All Excel Keyboard Shortcuts