Currency and dates have different .value2 from .value

If you look at VBA's help, you'll see a description of when you can expect this
behavior--it's not quite an explanation (to me), but it does describe it.

" wrote:

I didn't even know there was a Value2. Interesting.

I still don't get why the cell format changes the value that Excel
returns. Isn't the format just a MASK? When directly referencing the
cell (not using any variable), I don't see why a mask changes the
value.

Again.. with no variables involved:

? Range("A1")

You lose dp when A1 is formatted as currency. But you are correct that

? Range("A1").Value2

returns all the dp.

Just trying to understand the relationship between cell format and
returned values.

Thanks for your insight!

--

Dave Peterson