.value2 vba

description: the difference between .text, .value and .value2

.text

The present of cell. May get ####

.value

Get the cell value formatted. May get truncate decimal number.

.value2

Get the underlying value. Actual store value.