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