Value refers to what is stored in the cell. Text is what is displayed in
the worksheet. If I store 20.22 in a cell, I can format it to look like

$ 20

or
$20.22

Value2 is the same as value except in the case of currency where Value2
would return the date serial number and currency, a double. This is in
excel. I assume the web component functions similarly.

--
Regards,
Tom Ogilvy

"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