How to Convert Date into Date Khmer Format in Excel Speak Khmer

How to Convert Date into Date Khmer Format in Excel Speak Khmer
This video tutorial show how to input date correctly in Excel and then show how to format the date in khmer language using format cell.

Example how to use data format (Friday 04-March-2022):
- d  : 4 (day)
- dd : 04 (day)
- ddd: Fri
- dddd: Friday
- m : 3 (month)
- mm: 03
- mmm: Mar
- mmmm: March
- yy: 22
- yyyy: 2022
Convert to Khmer Date Format #1:
[$-km-KH,1200]dddd dd mmmm yyyy
[$-km-KH,1200]dddd ទីdd ខែmmmm ឆ្នាំyyyy

Convert to Khmer Date Format #2 (if formart #1 is not work):
[$-12000453]dddd dd mmmm yyyy
[$-12000453]dddd ទីdd ខែmmmm ឆ្នាំyyyy

Convert to Khmer Date Format #3 (if formart #1, #2 is not work):
[$-et-EE,1200]dddd dd mmmm yyyy
[$-et-EE,1200]dddd ទីdd ខែmmmm ឆ្នាំyyyy
Download Example Excel File below


Join My Special Courses To Level Up Your Skills: 👉 UP SKILLS 👈

Useful Links

Learn Code Khmer (HTML, CSS, JavaScript, ReactJS, PHP,...)
Free Download Khmer Books PDF
Telegram: ReanComputer101

2 Comments

  1. សួរស្តីលោកគ្រូ តើយើងអាចកំណត់ថ្ងៃខែចន្ទគតិលើ excel បាន ឬទេ?

    ReplyDelete
    Replies
    1. អរគុណច្រើន ខ្ញុំនឹងចេញ​វីដេអូថ្មីឆាបៗ

      Delete
Previous Post Next Post