Range.Value returns the underlying value of a cell, regardless of how
that cell is formatted for output. Range.Text returns exactly what
appears in the cell. For example, if A1 contains the number 987.1234
and is formatted for 2 decimal places, A1.Value would return 987.1234
while A1.Text would return 987.12. The Text property is read-only, so
you cannot assign a value to it. It is the Value transformed by
NumberFormat to display in the cell.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Fri, 26 Dec 2008 20:55:54 -0000, "Sean Farrow"
wrote:

Hi;
could somebody please explain the difference between rang.text and
range.value? When should I use both?
Chers
Sean.