On 26/01/2010 16:13, Dave wrote:
Hi all,

I've got an issue where I need a formula that when I put a date (or any
value) in cell A1, the text 'Closed' is automatically entered in cell B1
- I'm sure I've seen it somewhere before (probably used it too), but
I've searched in vain - can anyone help?

TIA


Dave

Thank you for your help gentlemen - I now feel rather stupid :(

--

Regards

Dave