Assuming that A1 contains your number, try...

=ROUND(A1/0.5,0)*0.5

Hope this helps!

In article <075CD72C-843A-4488-8D63-CF993195126B@microsoft.com>,
Stupid Scotsman <Stupid Scotsman@discussions.microsoft.com> wrote:

> Hello,
>
> Looking at the other posts ("I'm having some problems with the final stages
> of Fermat's Last Theorem") I feel a bit of a doofus for asking but I have
> some numbers (about 8000) rounded to 1 decimal place. I'd like to round them
> to the nearest 0.5 decimal places
>
> in order to demonstrate my stupidity futher I will provide two examples:
>
> I want 6.4 to become 6.5
> I want 6.1 to become 6.0
>
> D'ya catch ma drift?
>
> It seems "mround" might be the puppy I'm after but it doesn't seem to let me
> specify cells, only numbers???
>
> Many thanks in advance for replying (I'll feel really silly now if noone does)
>
>