Is it possible to only copy the formatted value and not the actual value in the cell? For example if I have a date, 11/12/05, and I format it to show Nov-05, when I copy the cell I only want it to paste Nov-05. What happens is that it still pastes 11/12/05 with the Nov-05 format. Any ideas?