I am attempting to use Paste Special, Paste Link to get a portion of one
worksheet linked to another. The source data is a mixture of data types,
some cells are text, some are dates and some are numerical.
Upon completing the Paste Link process, many of the cells contain 0, some
have a date 1/0/00. Reformatting doesnt seem to help, and the number of
cells is quite large which makes this impractical, in any event.
I can not determine why the cell formatting is not coming over properly.
Any suggestions will be helpful.
Marsh

just curious why dont you special paste the format first then try the links?

"Marsh" wrote:

I am attempting to use Paste Special, Paste Link to get a portion of one
worksheet linked to another. The source data is a mixture of data types,
some cells are text, some are dates and some are numerical.
Upon completing the Paste Link process, many of the cells contain 0, some
have a date 1/0/00. Reformatting doesnt seem to help, and the number of
cells is quite large which makes this impractical, in any event.
I can not determine why the cell formatting is not coming over properly.
Any suggestions will be helpful.
Marsh

"Marsh" wrote:

I am attempting to use Paste Special, Paste Link to get a portion of one
worksheet linked to another. The source data is a mixture of data types,
some cells are text, some are dates and some are numerical.
Upon completing the Paste Link process, many of the cells contain 0, some
have a date 1/0/00. Reformatting doesnt seem to help, and the number of
cells is quite large which makes this impractical, in any event.
I can not determine why the cell formatting is not coming over properly.
Any suggestions will be helpful.
Marsh

Try this:

A straight formula no links
=IF(A2="","",IF(CELL("format",A2)="D1",TEXT(A2,"dd/mm/yyy"),A2))

Regards
Peter