Hi John,

Value returns the value, Text returns the value and the format.

Quoting help

The only difference between this property and the Value property is that the
Value2 property doesn't use the Currency and Date data types. You can return
values formatted with these data types as floating-point numbers by using
the Double data type.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"john m" wrote in message
...
Hello,

Anyone know the difference between range.Value and Range.text?

And what is Value 2?

I am more interested in the Spreadsheet Control object (Office web
components) than the Excel deal.

I was testing for text in each cell and that worked fine until it gets
a
cell with a value but no text.

And i can't figure out how the values got in the spreadsheet they
don't
appear any different than text.

Thanks in advance for any clue...

jm