Just another option:

=CEILING(A1,10)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"gopi" wrote in message
...
How to convert this type of numbers in one formula
1145 =1150
1141 =1150
1149 =1150
12458=12460