Hi Montrose

Thank you for your quick reply.

I am able to change all the cells as you mentioned. Unforunately I have got
over 800 full pages to format and then double check with original hard
copies!! I wondered if there might be any other clever way to acheive the
same result so that they open up without the Dollar?

I am not sure why they would automatically convert to this if the 'language'
settings have been already changed to U.K?

Any other thoughts?

Cheers

Cat