WhatTheHeck?

[john m]

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

 

[Tom Ogilvy]

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.

 

[Bob Phillips]

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)