In .NET there does not seem to be a Value property. I use Value2.
Text also displays the text value. I have tried the get_Value method
but it takes a RangeValueDataType argument which is really what I am
looking for.

Excel seems to know when you enter a date that it should be transformed
into a double for storage but displayed as a date (it automatically
stores "m/d/yyyy" as the format for example). I am wondering if it
stores this information anywhere such as a datatype field or if it just
does the translation and set the format.

It seems like storing the RangeValueDataType object as a property of
the range would have been a nice thing.