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
Join My SPECIAL Course on Master 101 Excel Formulas Click Here to Chat with me for more information.
Download Example Excel File below
Similar Videos

2 comments:

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

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

      Delete