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

Try this out. Note that I've added a check to see if either the month
or day is less than ten, and if so, lead that figure with a zero.

="="&IF(MONTH(Sheet1!A1)<10,"0"&MONTH(Sheet1!A1), MONTH(Sheet1!A1))&"/"&IF(DAY(Sheet1!A1)<10,"0"&DAY(Sheet1!A1),DAY(Shee t1!A1))&"/"&YEAR(Sheet1!A1)


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=398417

Sorry, never mind.


--
Piranha


------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=398417

Excel Geek,

Excellent solution it worked perfectly I just had to change it slightly
so the day and month read in the UK style.

I feel slightly relieved it was fairly complicated after all (for me
anyway).

Thanks again.
AU


--
AcesUp
------------------------------------------------------------------------
AcesUp's Profile: http://www.excelforum.com/member.php...o&userid=26519
View this thread: http://www.excelforum.com/showthread...hreadid=398417