Hi all,

Have search the groups but didn't find an answer to my problem,
therefore here my question.

Same workbook, two different sheets. Excel 2003 on W2000

source cells: Range of cells are formatted as custom date. Majority of
cells contain valid date, some of them contains text as: no date for
invoice (without any quotes etc.)

target cells: empty and formatted as custom date (same as source cells)

Applying a macro that copies source to date (no formatting) with a
copy/paste (not copy value) sometimes screws up the format of the
target cells transforming them to general, and of-course displaying a
number i.e. of the date.
The strangest thing is that it screw up randomly.

Any ideas ?

Best regards,

Ronald.