=CEILING(A1,100)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"r4319hb" wrote in message
...
how to roundup the number to hundreds example 1250101 to 1250200 , 1250901
to
1251000 , 1250750 to 1250800
thank alot