Thanks Jason

X will always be a number so I'll try declaring the variable X as "Double" rather than "Variant".

Should the Round and Format functions work then?

Greg