find the decimal

  • Thread starter Thread starter SMILE
  • Start date Start date
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
 
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
 
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
 
Hi Smile!

One way. Try:

=--RIGHT(A1,LEN(A1)-FIND(".",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.
 
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
 
Back
Top