The idea was to either accept a value  to two decimal places wather
from a currency field or a general field with a '£' tagged onto the
front.

The "=ROUND(A1 * 4, 0) / 4" seems to do the job though, so I guess I
should spend more time familiarising myself with what's already on
offer before trying to re-invent the wheel :)

For future reference though - where should I paste the code in order
to get the cell  references to work?

I tried it in modules(worksheet + personal) and the worksheet and all
I was getting was a #Name? error,