format changes after copy/paste

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

.

Quantcast