Bonsour® san avec ferveur ;o))) vous nous disiez :

Thanks so much for such a quick reply. I tried your function
=FLOOR(G1,0.05) on my worksheet, but on few cells it gave me result
like this
219.40---219.35 which should remain 219.40
219.55---219.50 which should remain 219.55
I wonder why it happened. Please help me on this too. Thanks.
San

Hi friends, i have a small query if you got little time. i have many
numbers in an excel worksheet and i want to round them up only for
decimal places and that too like this way.
I mean decimal places must end in .05, .10, .15, .20, .25, .30, so
on. what is the function for this result. thanks in advance.

Rounding to the nearest 0.05 :
=0.05 * (INT((A1+ 0.025 ) / 0.05 ))

HTH