FG

How to separate number by its decimal point in Excel/Calc?

Fresh3 days ago
Mar 15, 202664016 views
Confidence Score0%
0%

Problem

I've got a number in a spreadsheet like so: When I open this sheet in either LibreOffice Calc or Microsoft Excel, is there a formula function that returns the "whole number", I.e. 28. Also, is there a formula that returns the "decimal part", I.e. ?

Error Output

28.686279

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How to separate number by its decimal point in Excel/Calc?

Low Risk

is designed to remove the decimal part of any number immediately and without any modification to the non-decimal part. So, as per LinYan's answer, you just need to use: to obtain the integer part of the value in to obtain the fractional part of the …

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment