[Excel][pvid]

[Windows][pvid]

[How-To][pvid]

## 41. How to Convert Number and Date to Khmer Number and Date in Excel

41. How to Convert Number and Date to Khmer Number and Date in Excel
(របៀបបំលែងលេខ និង ថ្ងៃខែឆ្នាំទៅជាភាសាខ្មែរ)
In this Excel tutorial in Khmer show you step by step how to convert Number (1,2,3,...) into Khmer Number (១,២,៣, ...) and date like 20/06/2022 into Khmer date (ថ្ងៃចន្ទ ទី២០ ខែមិថុនា ឆ្នាំ២០២២).

```Number to Khmer Format: [\$-kh-km,1200]0
Date Format in Khmer: [\$-kh-km,1200]dddd dd mmmm yyyy

```

Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel

## 42. How to Prepare Excel File for Printing speak Khmer

42. How to Prepare Excel File for Printing speak Khmer
(រៀបចំឯកសារបោះពុម្ភ Print + PDF)
If you want to print Excel document, here some tips and trick would help you. You may need to do the following:

1. Page Setup:
- Margin: Left, right, top, buttom
- Paper: A4
- Orientation: Lanscape or Portrait
2. Check Printer setting: Paper = A4

Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel

## 40. How to Split Date and Convert to Date Format in Excel Khmer

How to Split Date and Convert to Date Format in Excel Khmer
(បំបែកថ្ងៃខែឆ្នាំ និង តភ្ជាប់ជា Date វិញ) - In this Excel tips show how to split date into number as Day, Month and Year in normal value. Then show you how to convert that numbers into date format with help of DATE formula.
DATE Formula: Convert number input into Date format
=DATE(Year, Month, Day)
◾ Year: Required, number of year.
◾ Month: Required, number of month.
◾ Day: Required, number of day.

Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel

## 39. Date Formulas in Excel (Now, Today, Day, Month and Year)

Date Formulas in Excel (Now, Today, Day, Month and Year)
In this Excel tutorial show you the different Now() and Today() formula and also how to get Day, Month, Year from date too.

NOW Formula: return current date and time
=NOW()

TODAY Formula: return current date only
=TODAY()

DAY Formula: return number of day from date
=DAY(serial_number)
◾ serial_number: Required, is your date.

Month Formula: return Month from date
=Month(serial_number)
◾ serial_number: Required, is your date.

Year Formula: return year from date
=Year(serial_number)
◾ serial_number: Required, is your date.

Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel

## 38. How to Create New Line in Excel Khmer

38. How to Create New Line in Excel Khmer
(របៀបចុះបន្ទាត់ និង ទំលាក់ជាពីរជូរ) - In this Excel tutorial in Khmer how to create new line of text in a cell with shorcut key and wrap text.

Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel

## 37. How to create Drop Down List in Excel Khmer

37. How to create Drop Down List in Excel speak Khmer
(របៀបបង្កើត Drop Down List) - In this Excel tutorial show you two ways to create simple drop down list.

Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel