Thanks Gmajor this has worked perfectly.

One last question for larger values is to possible to get a , between the zeros ie 25,000

Also I would then be looking to use the the SQFT to work out the rent i.e

£ (____) pa, equating to £ (____) psf (£ (____) psm).

So if I enter the PA value it will out out the PSF and PSM. Is this possible?

I will then look to run similar Macros but in different parts of the doc, do I just re name the plain text content in the different area say SQFT1 and add a new module as rename the code from 'SQFT' to 'SQFT1'.

Alot of question but much appreciated

Thanks