Hello,

Thanks to all for your replies. Before running into this scenario, I
thought that the Value property of a cell was what was actually stored
in the cell (what you see in the Formula bar), and all that formatting
did was change what was displayed in the cell. Obviously, my
assumption was incorrect, although I'm still not clear as to why.
I'll have to think about this for a while.

Dave, from what you've said, I'm assuming the Value2 property
should always be used when working with Date and Currency formats. Do
you need the Value2 on both sides of the equation? Both of these lines
seemed to produce the same (correct) results in this instance.

Cells(1, 3).Value = Cells(1, 1).Value2
Cells(1, 3).Value2 = Cells(1, 1).Value2

Thanks for your help,

Regards,

DaveU