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: 2022Convert to Khmer Date Format #1:
[$-km-KH,1200]dddd dd mmmm yyyy
[$-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
[$-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
[$-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
សួរស្តីលោកគ្រូ តើយើងអាចកំណត់ថ្ងៃខែចន្ទគតិលើ excel បាន ឬទេ?
ReplyDeleteអរគុណច្រើន ខ្ញុំនឹងចេញវីដេអូថ្មីឆាបៗ
Delete