See my answer to your previous post.

In article ,
"John Britto" wrote:

I shall be thankful if any one helps me to create a macro or so..to solve the
following:

I have hunderes of cells with 8 digits decimals. When I click a maco the
cell to be updated as:

Present value: 1520.12565415
Desired Result: =1520.125+0

Thanks for the attentino.

John Britto