Rounding numbers

[time conversion]

I have a large row of numbers that I need to round to the nearest 5, so I
used a formula of (=mround(A1:A3000,5) but this didn't work......anyone
have any ideas?

 

[Teethless mama]

=MROUND(A1,5)

copy down as far as needed

 

[time conversion]

Teethless...thanks....great!

=MROUND(A1,5)

copy down as far as needed

 

[Infinitogool]

Hi time
Try this formula in cell B1

=mround(A1,5)
Copy down as far as needed

Regards,
Pedro J.

 

[time conversion]

teethless....if the numbers are already in the row....what cell can I write
that formula in without that number disappearing?

 

[RagDyeR]

Are the numbers keyed in, or are they the returns of formulas?