Ok this is one of those one that is probably so simple I've overlooking
the obvious solution.
I have two sheets, on sheet one in A1 I have 09/12/2005
On sheet two in cell B1 I would like to use a formula (or anything that
will work) that looks at cell A1 on sheet 1 and then formats it to
read,
=09/12/2005
I've tried =IF(Sheet1!A11,"=Sheet1!A1") but this just left the cell
to read,
=Sheet1!A1
Which doesn't work when I try and apply a advanced filter.
Thanks for any help in advance.
AU
--
AcesUp
------------------------------------------------------------------------
AcesUp's Profile:
http://www.excelforum.com/member.php...o&userid=26519
View this thread:
http://www.excelforum.com/showthread...hreadid=398417