Hi

I have two worksheets in one I am asking it to copy what is in the other on
a specific cell. The first worksheet has dates and blank cells when the
second sheet copies it changes the date format to a strange numbering and
where it should be blank makes up a date - I have also tried requestein if
blanl levae blank otherwise copy and still no good

Example
Sheet one Sheet two
01/05/09 4568
0/01/1900
15/07/09 3576

The two formulas used in sheet two have been
='05th August Issues'!M2

and

=IF('05th August Issues'!M2="","",M2)

Thanks

Lise