decimal point

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My question is how can i show integer value and value after decimal value into two different cell
Exm.

Like Number is 25.588

Show Like into Cell A1=25
Cell B1.588
 
Hi Arjun!

=INT(A1)
Returns the integer portion of the number in A1

=MOD(A1,1)
Returns the decimal portion of the number in A1

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Use the TRUNC worksheet function to return the integer
part of the number.

Example

Cell A1 contains 25.88

=TRUNC(A1) returns 25

I don't know if there is a function for the other part of
the number
-----Original Message-----
My question is how can i show integer value and value
Click to expand...
after decimal value into two different cell
 
Back
Top