decimal point

[arjun]

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

 

[Norman Harker]

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.

 

[Mark]

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

after decimal value into two different cell