How to Split Decimal Number into Two Parts in Excel (Khmer)

Hello everyone! Today I show you how to split decimal number into two parts in Excel step by step with easy formulas and video guide in Khmer language.

For example, if you have number 101.25 in cell A2:

• Integer part (Whole number): 101
• Decimal part: 0.25

Method 1: Get Integer Part (Whole Number)

To extract integer part only from number 101.25:

Use INT or TRUNC formula:

=INT(A2)

or

=TRUNC(A2)

Result will give you 101.

Method 2: Get Decimal Part Only

To extract decimal part only (0.25) from number 101.25, you have 2 easy options:

Option A: Subtract Integer from Original Number

=A2 - INT(A2)

Option B: Use MOD Function

=MOD(A2, 1)

Both formula will give you exact result: 0.25.

📹 Watch Khmer Video Tutorial

Watch video step by step below to see how to split decimal number easily in Excel:

💡 Quick Tip:

• If your decimal part show many digits like 0.250000000000001, you can format cell to 2 decimal places or wrap with ROUND(A2 - INT(A2), 2).
• Use INT when working with positive number, but for negative number like -101.25, use TRUNC(A2) to get -101 cleanly!

📚 Related Resources

• INT vs TRUNC Function in Excel (Video in Khmer)
• ROUND vs ROUNDUP vs ROUNDDOWN Function in Excel
• Top 15 Basic Excel Formulas Every Beginner Should Know
• How to Use Clean Text Formula in Excel