Dave,
As I understand it:
With ActiveCell
.Value = "1/1/2005"
MsgBox .Value2
End With

you can see that the .Value would depend on the format of the locale, but
..Value2 gives you DateSerial so you know exactly which day is meant.
Same thing with currency and decimal/digit grouping symbols.

NickHK

"DaveO" wrote in message
...
So, looking at the HelpFile it says that the difference between .Value and
.Value2 is that the latter does not accept Currency or Date data types.

With that in mind, why would you ever wish to use .Value2? To me it seems
that it's limiting and offers no real value.

Can anyone tell me why it'd be better to use .Value2 over .Value.

TIA.