Re: Cell's Value vs Text Property
Just to add to comments, also of note is the Value2 property, particularly when dealing with dates.
eg enter a date in A1 02/05/05 format the cell as dddd/mmm/yyyy.
you will get:
.Text Monday/May/2005 '(the text as displayed in cell)
.Value 2/05/2005 '(depends on your windows reginal shortdate)
.Value2 38474 '(the date serial number)