the apostrophe only shows up in Destination cell B6;
I'm running Excel 2003
I appreciate your generous input into this situation
and have copied it off to take to work on Monday,
where the application )at my office)..

I have tried previously formatting the destination sheet B Column
as Text (And Saved) before running Macro again.
YOur recommendation to : Copy/Paste the first two columns normally, then the
third and fourth as Special-Values is very worthwhile;

Appreciate everything,,
Jim May


"Mark Lincoln" wrote:

Jim,

Okay, I'm seeing this a bit more clearly now. Maybe because I'm not at
work. :-)

If I copy a cell with a series of zeros stored in a cell formatted as
Text and paste it into another cell, I only get the zeros. No
apostrophe, whether I merely Paste or Paste Special - Values. I'm now
wondering how you get that confounded apostrophe. And am I correct in
assuming it only shows up in B6?

What's strange is that if I don't choose the "Keep Source Formatting"
option after the Paste, the zeros are all still there even though the
destination cell keeps General formatting. And yet, no apostrophe
(Excel 2002). The more I look at this, the confuseder I get - and the
more I want to get to the bottom of this. Which version of Excel are
you using?

Also, do you actually need to Paste Special? That is, are DepAmt and
DepDate also stored as text?

Perhaps you need to Copy/Paste the first two columns normally, then the
third and fourth as Special-Values. Or at least you might need to be
sure your destination cells in column B are formatted as text before
the Paste operation.