find the decimal

S

SMILE

Hey

I have a number in A1 as 33.56 and I need a formula to display in B1 as
56 ( that is the decimal part).
Hope u see some tips

Thomas
 
A

Andy B

Hi

In B1 try
=A1-INT(A1)

In your example, this will give you .56
If you want to get 56, not .56 use

=(A1-INT(A1))*100

Andy
 
S

SMILE

Andy
Thanks for your reply, but it is not necessary that always I have tw
digits . So *100 will not be appropriate always.

Thanks
thoma
 
N

Norman Harker

Hi Smile!

One way. Try:

=--RIGHT(A1,LEN(A1)-FIND(".",A1))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
R

Ron Rosenfeld

Hey

I have a number in A1 as 33.56 and I need a formula to display in B1 as
56 ( that is the decimal part).
Hope u see some tips

Thomas
Click to expand...

=MOD(E3,1)*10^(LEN(TEXT(MOD(E3,1),"@"))-2)

This will not display any trailing zeros.

For example, if you have number formatted so it shows 33.5600, the above
formula will still display 56.

If you require that it display 5600, then post back as we'll have to use a
Visual Basic routine to do so.


--ron
 
Top