I neglected to say i will be grateful for the code for both negative numbers
and positive numbers, i have used the floor or ceiling function to date on
positives but does not appear to work on negatives
--
with kind regards

Spike


"Spike" wrote:

I will be very grateful for the code to round a number to the nearest 100

Many thanks
--
with kind regards

Spike