I don't know what the issue was - it worked fine when I recorded it but differently when run as a macro. There was nothing in VB to show what formatting I had set.

Thanks for your help anyway.