Thanks very much T. Valko - it was driving me nuts! Improves productivity at
my desk no end

Cherie

"T. Valko" wrote:

Try this:

A1 = 1825.27

=ROUND(A1/0.05,0)*0.05

--
Biff
Microsoft Excel MVP


"Cherie QLD" <Cherie wrote in message
...
is there a formula to round just the decimal place? I want to show
$1825.27
as $1825.25, and not $1825. I need to round to the nearest 0 or 5.