Hi Clara,

The 'text' value is what is displayed in the cell whereas the 'value' is the
value behind what is displayed.

as an example put the number 1.4999999 in a cell with the cell formatted to
2 decomal places.

the value = 1.49
the text = is 1.5

Mike

Mike
"clara" wrote:

Hi all,

object range has value and text property, which is different between them?

Clara
--
thank you so much for your help