Pick up numbers after decimal.

[shyam]

I have table wherein I need to pick up the first two figures after the decimal alongwith the decimal. eg.

0.452 Answer would be .45
3.152 Answer would be .15
2.162 Answer would be .16

Can anyone help me out on this?

Thanks n rgds
Shyam

 

[Special-K99]

Probably a better way but this works

=INT((D1-INT(D1))*100)/100

 

[MarcelBeug]

Alternative:

=TRUNC(MOD(D1,1),2)

 

[shyam]

Alternative:

=TRUNC(MOD(D1,1),2)

Many thanks...

rgds

shyam

 

[MarcelBeug]

You're welcome.