Try

=CEILING(A1,100)

and copy down.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"steve" wrote in message
oups.com...
Basic question Im sure.
I have a list of numbers

23456
45677
34567
etc.

and I want to use this formula on them.
=CEILING(#####,100)

How can I easily add the format or formula (what ever it is called) to
the whole list eg so the column looks like this.

=CEILING(23456,100)
=CEILING(45677,100)
=CEILING(34567,100)

When I put the fomula in the first line and then drag the corner of
this cell down , it just copies the first line over the others and does
not add the formula to each line.

=CEILING(23456,100)
=CEILING(23456,100)
=CEILING(23456,100)
=CEILING(23456,100)

Thanks Im sure this is basic. Im using XL 97

Regards